Unable to open BCP host data-file

#1

It could be the -i switch try this :-

bcp database..WKCE in c:\cg10grt.txt -fc:\wkce.fmt -
SServer -Uusername -Ppassword -ec:\wkce.err

HTH

Ryan

Quote:

-----Original Message-----
I am logged on to the server and need to load multiple
files into a table.

The file I am loading I am able to open with notepad.
The
format file I can also open in notepade.

When I am run the command on the server:

bcp database..WKCE in -fc:\wkce.fmt -ic:\cg10grt.txt -
SServer -Uusername -Ppassword -ec:\wkce.err

The error I receive is:
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open
BCP host data-file

Any assistance would be helpful.

Thanks.
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Unable to open BCP host data-file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Unable to open BCP host data-file - 10-02-2003 , 09:56 AM