Create/export csv file from sql server table

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

alonzo SSC-Addicted Points: 443 More actions · Answer 1

An easy way is to create a DTS package that exports the file or table in csv format then call it inside your stored procedure like:

exec master..xp_cmdshell 'dtsrun /S "ServerName" /U "UserName" /P "Password" /N "PackageName"'

David Burrows SSC Guru Points: 65143 More actions · Answer 2

or use BCP

exec master..xp_cmdshell 'bcp database.owner.tablename out outputfilename -c -t "," -S servername -T'

Far away is close at hand in the images of elsewhere.
Anon.

tsage Grasshopper Points: 19 More actions · Answer 3

Hello,

This works, but I get character zero in null fields. Is there a way to eliminate these?

Thanks

Tom