Importing data with BCP using a query...

Hi all,

I'm trying to import updated unitcosts into a products table without
doing a complete dump and then reimport.

I can't seem to get BCP to accept a query instead of a table - here's
the text of the command:

bcp "update ecomerce.dbo.cmrc_products set unitcost = @unitCost where
productID=@pid" in unit1.txt -S [server] -T

I get an error that reads: An error ocurred while processing the
commandline.

Any help would be appreciated.

Thanks.

Tom

.

Relevant Pages
Loading