Bulk Insert Problem in SQL Server Management Studio 2005

175 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Eabouzeid
    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.
    175 pointsBadges:
    report
  • Eabouzeid
    [...] Eabouzeid was having a bulk insert problem in SQL Server Management Studio 2005 and Mr. Denny helped him figure out the [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following