I am loading varchar(max) / nvarchar(max) data from sql server to Teradata using TPT and data direct drivers. The trimmed length of varchar(max) column is 5356651. I am unable to load this data as data dorect drivers replaces varchar(-1) instead of varchar(max).
Any idea how I can load this data into teradata?
In TPT (and Teradata) the max size of a VARCHAR column is 64000 bytes.
If you have a column holding character data that exceeds 64000 bytes, it seems as though yuo are referring to a CLOB.
The TPT ODBC operator does not currently support LOBs and cannot export LOBs from SQLServer.
Essentially, the ODBC operator cannot export any columns that exceed 64000 bytes from SQLServer.
Thanks for the response. Is there any other way I can load column from sql server to teradata that exceeds 64000 bytes?
Right now, the only way is to export the LOB-sized data from SQLServer via some other tool, write the data out to a file, and then load from that file into Teradata with TPT.