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.
| Author |
Topic |
|
jsiedliski
Yak Posting Veteran
61 Posts |
 Posted - 2002-09-24 : 14:42:29
|
| I am using DTS to export a table to a comma seperated file. It appears that the export is truncating fields to 255 characters. I am not using BCP because I need a double quote text qualifier (pretty sure, I can't specify text qualifiers in BCP).Any thoughts? I checked all DTS settings (properties has noting regarding field size, also verified that in the "Transorm Data Task", the destination field is set to 512). Could this be an ODBC setting issue?Thanks,jack |
|
|
jsiedliski
Yak Posting Veteran
61 Posts |
|
|
|
|
|
DTS export to .csv truncating to 255