DTS out varchar greater than 255 characters

[jballum]

Is there a known bug when using DTS to export a data column that is more than 255 characters? I have a varchar column in a table that is truncating at 255 after the successful export has completed.

I figure there has to be a setting that I am missing that will enable the whole string to be exported.

Anybody know of any?

Thanx

JB

 

[skuhlman]

Try either changing the field type to TEXT/NTEXT or doing a cast or convert to a TEXT/NTEXT type when exporting.

 

[jballum]

Didn't help.

JB

 

[NCB]

Make sure your DTS package is using Microsoft OLE DB Provider for SQL as the datasource. If you are using ODBC, then make sure that you have the latest MDAC (7 I think).