Home > IT Answers > SQL Server > Bulk Insert Problem in SQL Server Management Studio 2005
Eabouzeid
175 pts.
 Bulk Insert Problem in SQL Server Management Studio 2005
SQL INSERT, SQL Server Management Studio 2005, T/SQL
Hi. I'm running into an issue performing a bulk insert. I've taken the following steps:
  • Created a table
  • Created a schema file with a .fmt extension
  • Created a stored procedure to insert a file
When I attempt the bulk insert I get the following error message: Cannot bulk load because the file "g:USB06182010.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.). Does anyone have any ideas?

Software/Hardware used:
SQL Server Management Studio 2005
ASKED: June 18, 2010  3:46 PM
UPDATED: June 21, 2010  5:49 PM
RELATED QUESTIONS
Answer Wiki:
Does the G: drive exist on the SQL Server? Is it a mapped drive? If it is you a UNC network path instead of a mapped drive.
Last Wiki Answer Submitted:  June 18, 2010  8:52 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I see the problem now. Thanks for helping me. I did not realize that the source file has to be on the SQL server. I thought it could be on my local computer, but I don’t think that’s the case.

Eabouzeid
 175 pts.