Delimiting file through DTS

[sgd3476]

I've created a DTS package to export a query from SQL. I need to have the file comma or pipe delimited. The file is too large to manually delimit.
Thanks for any help.

Steve

 

[nigelrivett]

Why use dts? It's a single sql statement to do it via bcp

exec master..xp_cmdshell 'bcp "myquery" out c:\myfile.txt -c -t|'

see bcp in bol.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[johnherman]

Always remember bcp !!
When DTS came out, my Microsoft buddy told me it was bcp on steroids.


Sometimes the grass is greener on the other side because there is more manure there - original.