Home Forums SQL Server 2008 SQL Server 2008 - General Export to CSV? RE: Export to CSV?
ahthomas
Ten Centuries
Points: 1382
More actions
January 2, 2013 at 9:07 am
#1572928
Thx for the reply.
So, something like this, but using xp_cmdshell? 'sqlcmd -q "select col1,col2,col3 from table" -oc:\myfile.csv -h-1 -s","'
What about a retention period of these files? I guess I need a batch file?