bpc Headers using -F
Posted: Thu 08 May 2008 16:03
I'm trying to figure out the why my bpc command to insert headers isn't working properly. Here's what I have.
bcp "SELECT (setname + CONVERT(NVARCHAR(MAX), number)) as mergeData, sellprice, sellprice FROM MtgoData.dealer.CardsView c WHERE isfoil=0" queryout m:\regularprices.txt -U beta -P gettowork -S tcp:192.168.86.100\SQLEXPRESS,14430 -c -C ACP -t , -F "Product code, Price, List price"
The error I get is:
The -F flag must be followed by a positive integer.
'Product code, Price, List price' is not a legal positive integer.
What's the proper syntax to getting the header to read Product code, Price, List price?
Thanks for the help!
bcp "SELECT (setname + CONVERT(NVARCHAR(MAX), number)) as mergeData, sellprice, sellprice FROM MtgoData.dealer.CardsView c WHERE isfoil=0" queryout m:\regularprices.txt -U beta -P gettowork -S tcp:192.168.86.100\SQLEXPRESS,14430 -c -C ACP -t , -F "Product code, Price, List price"
The error I get is:
The -F flag must be followed by a positive integer.
'Product code, Price, List price' is not a legal positive integer.
What's the proper syntax to getting the header to read Product code, Price, List price?
Thanks for the help!