sqlcmd question

[takaoki]

Hi,

Can I use sqlcmd to output to a "comma" (not tab) delimited file? I don't see any options to do this...

Thanks

 

[takaoki]

Ok, I figured out how to do the comma (-s, -W)

sqlcmd -S myServer -d myDB -s , -W -Q "SELECT Ticker [Ticker], DataValue [Eqy_out] FROM myTab WHERE AsOfDate <= 'Oct 2 2008 12:00AM' AND ValidToDate >= 'Oct 2 2008 12:00AM' AND Field = 'EQY_SH_OUT'" -o e:\tmp\myFile.csv

But the file looks like this:

Ticker,EQY_SH_OUT
------,----------
EVG CN,79.908730
FSY CN,77.085230

Which I don't want... how do I fix the header so that it doesn't put the comma between the column names and no dashed line?

Thanks

 

[mutley1]

Have a look at the parameters on the microsoft site (usually a good place to start).....

http://msdn.microsoft.com/en-us/library/ms162773.aspx

I do not believe you can remove the dotted line, and why would you want to remove the commas from the header, because if you try to import it to anything (including Excel), it will not know how split the headers of the colums. If you are using SSIS or DTS to import, just set the option to "my file has a header record" and it will ignore the first line.

Cheers,

M.

 

[MDXer]

Try using BCP ionstead.


[URL unfurl="true"]http://msdn.microsoft.com/en-us/library/ms162802.aspx
[/url]

A SSIS package would be the better solution if that is an option.


Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck