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
 Import/Export (DTS) and Replication (2000)
 DTS exports with commas in column names

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-13 : 19:32:42
Bill writes "Hi, I'm trying to do a simple export of data from a SQL Server table to a comma-delimited text file. What's troubling me is that the columns I'm trying to export can have a comma in their names so the DTS engine parses the column names incorrectly and I get "column not found" errors. It doesn't matter whether I set the text qualifier or not. I still get the errors. Anyone know how to get around this? Thanks in advance."
   

- Advertisement -