gs79
asked on
bcp is not a recognized as an external/internal command or operable program or batch file
Its a continuation of the question I asked here.
https://www.experts-exchange.com/questions/26645714/Msg-102-level-15-state1-Line-2.html?anchorAnswerId=34234293#a34234293
after this I created the objects running another sql script.
Now I am trying to bulk load the data into the tables using the following program. But I ran into this error:
"bcp is not a recognized as an external/internal command or operable program or batch file"
the data files and the batch file are in this location:
C:\owbcode\ACME_POS_Data_L
I navigated to the above directory in the command prompt and executed the batch file acme_pos_bulk_load_data.
Here is the content of the batch file in the code snippet.
please advice how to over come this problem
many thanks..
https://www.experts-exchange.com/questions/26645714/Msg-102-level-15-state1-Line-2.html?anchorAnswerId=34234293#a34234293
after this I created the objects running another sql script.
Now I am trying to bulk load the data into the tables using the following program. But I ran into this error:
"bcp is not a recognized as an external/internal command or operable program or batch file"
the data files and the batch file are in this location:
C:\owbcode\ACME_POS_Data_L
I navigated to the above directory in the command prompt and executed the batch file acme_pos_bulk_load_data.
Here is the content of the batch file in the code snippet.
please advice how to over come this problem
many thanks..
bcp ACME_POS.dbo.Employees in Employees.dat -f Employees-n..xml -T -S VirtualXP\SQLExpress
bcp ACME_POS.dbo.Items in Items.dat -f Items-n..xml -T -S VirtualXP\SQLExpress
bcp ACME_POS.dbo.Regions in Regions.dat -f Regions-n..xml -T -S VirtualXP\SQLExpress
bcp ACME_POS.dbo.Registers in Registers.dat -f Registers-n..xml -T -S VirtualXP\SQLExpress
bcp ACME_POS.dbo.Stores in Stores.dat -f Stores-n..xml -T -S VirtualXP\SQLExpress
bcp ACME_POS.dbo.Vendors in Vendors.dat -f Vendors-n..xml -T -S VirtualXP\SQLExpress
bcp ACME_POS.dbo.POS_Transactions in POS_Transactions.dat -f POS_Transactions-n..xml -T -S VirtualXP\SQLExpress
you need to run the command from wherever the bcp tool is located at. if you drop the bcp or a copy of it (named bcp.exe) to the system32 directory you should be able to run it w/ no problems.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
FOTC -
Awesome, I coped all the dat files and batch file to the default location as mentioned in the above thread and executed by navigating to directory in cmd window..
It worked great and loaded all the data.
Copying the bcp tool to system32 folder and executing by navigating to the files in the original directory (C:]owbcode\...) did NOT work..
Thanks
GS
Awesome, I coped all the dat files and batch file to the default location as mentioned in the above thread and executed by navigating to directory in cmd window..
It worked great and loaded all the data.
Copying the bcp tool to system32 folder and executing by navigating to the files in the original directory (C:]owbcode\...) did NOT work..
Thanks
GS
excellent! glad i could assist! happy copying! =)
ASKER