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 |
|
skond
Yak Posting Veteran
55 Posts |
 Posted - 2002-11-14 : 13:52:53
|
| Can someone help me with this.I need to bcp a table to a comma sperated file. I want to use text_qualifier as double quotes and the first line of the text file to contain the column headers.This can be easily done using DTS but I need to use bcp because I'm trying to automatically generate the table names in a script.Your help will be greatly appreciated. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-11-15 : 08:11:43
|
| I don't think either requirement can be fulfilled directly with BCP ... You may be able to write a proc to generate your source rowset in the format that you want and then use that proc as the "query" arg for bcp.On the other hand, dynamically generating the source and destination with DTS isn't that hard either ....Jay White{0} |
 |
|
|
|
|
|
Need help with bcp