There is probably something simple I am overlooking here and I have been looking at this now for over 45 minutes.
My eyes hurt.
I am trying to some data from sql server to .csv file.
The file needs to be pipe-delimited with double-quoted identifier.
Everything seems to work fine except each header column and associated values are not being wrapped around double quotes.
Any ideas where I am going wrong?
According to the commands I looked up -I (dash i) is supposed to enable double quotes as text identifier.
However, I don't see the double quotes when viewing the outputted data.
Any ideas where I overlooking things or screwing them up?
Here is the "mostly working" code.
And thanks in advance
sqlcmd -S crt3 -i c:\TYLER\ENSA.sql -o c:\inetpub\ftproot\PROD\ENSA.csv -h 8192 -s"|" -w 5000 -W -I