Microsoft SQL Server 2012, 2014, 2016, and 2019
ODBC, OLEDB (64-bit)
Bulk write support is available for standard and in-database workflows.
|Type of Support||
Read & Write, In-Database
Database version: 10, 11, 12, 13
Alteryx tools used to connect
Standard workflow processing
- Maximum Columns In Table: 1024
- Maximum Column Name Length: 128 characters
- Maximum Row Size: 8060 bytes ( does not include LOB size )
LOB data must all be at the end of the select. If user enters a SQL statement that doesn't have them at the end of the statement they get an error, "This ODBC driver requires that all BLOB fields be at the end of the select.". A "select * from table" will move all the LOBs to the end.
There is a limit for SQL Server for varchar(max) of 16777216 characters (read and write). Data above this limit is truncated.