Incorta Data Pull to MS SQL
While trying to run Incorta query in MS SQL, getting following error OLE DB provider 'MSDASQL' for linked server 'incorta' returned data that does not match expected data length for column '[MSDASQL].colName'. The (maximum) expected data length is 8000, while the returned data length is 14258. Can anyone plz help if there is way to increase the data pull to 14258.
I have seen this before when trying to pull fields of type TEXT from a Postgres table into SQL Server. My solution was to:
1) Add the parameter: TextAsLongVarchar=1 to the connection string
2) Add the parameter: MaxLongVarcharSize = XXX to the connection string. Set XXX to an appropriate size
3) Bring the Postgres TEXT field into a field of SQL type VARCHAR(MAX)
Not sure if this is your situation but maybe will point you in the right direction.