Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 varchar fields and DTS export

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-19 : 12:50:50
Chandra writes "I am using SQL Server 2000. Varchar and char fields of size > 255 are being truncated to 255 charecters when exported to text file using DTS import/export wizard.
Am I missing any settings or options in my server. I have checked transformations and are correctly set."

jsiedliski
Yak Posting Veteran

61 Posts

Posted - 2002-09-24 : 14:37:36
Did you ever find a solution to this issue? I am having the same problem. Nothing it the DTS properties or settings that I could find. Could this be an ODBC issue? I am exporting to a .csv file format.

Thanks,

Jack

Go to Top of Page
   

- Advertisement -