bpc Headers using -F

tweaker · Post by **tweaker** » 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!

Antaeus · Post by **Antaeus** » Mon 12 May 2008 06:28

It looks like this question does not concern SDAC. For more information about the bcp utility please see SQL Server Book Online.
Feel free to contact us if you have any SDAC-related questions.