Hi!
I have encountered the following error when using Feature Writer transformer (dynamic workspace) writing a Microsoft SQL Server Spatial table.
2025-08-06 16:11:20| 148.0| 0.0|ERROR |Microsoft SQL Server Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE [Infrastructure].[Fire_Hydrants_Audit] ([FH_ID] bigint, [Work_Required] bit, [Paint_Post] bit, [New_Post] bit, [Paint_Surround] bit, [Clear_Vegetation] bit, [Post_Reflector] bit, [Inspection_Date] datetime2, [Inspected_By] varchar_max, [Works_Completed] bit, [MI_PRINX] integer, [SP_GEOMETRY] geometry)'. Provider error `(2715) Column, parameter, or variable #9: Cannot find data type varchar_max.'
Any thoughts how to resolve this?
Thanks!