Bulk Insert Task Error
I get this error while trying to bulk insert from a flat file to a database table. [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\Users\sharaths\Desktop\New Text Document.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).". Please help Sharath
May 11th, 2011 6:03am

As the error states, the file cannot be opened because the file cannot be found. Does the file exists? Perhaps you should look at moving it to a different location instead of trying to access the Desktop folder.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 6:10am

Of course it exists. It had been inside my D drive and since I got the error, tried it on Desktop..But no go...Same error
May 11th, 2011 6:16am

Try renaming your file to Document.txtJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 6:18am

Just tried and gets the same error.. [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\Users\sharaths\Desktop\Document.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).".
May 11th, 2011 6:22am

hi sharath 048 i think you are in client machine u just move the file into server and do same....... thanks nathan
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 6:30am

Where is SQL Server located? Is it on the same PC as the file? If not, you need to either move the file to the machine running SQL Server or create a UNC share pointing to the file on your machine. The Bulk Insert task runs by executing sql command (bulk insert) internally on the target sql server to load the file. Therefore it is looking for the file "C:\Users\sharaths\Desktop\Document.txt" on the serverJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
May 11th, 2011 6:31am

The SQL Server is not located on the same machine which has the txt file. I may not be able to move it to the server. But what excatly is a "UNC Share". Can you explain?
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 8:02am

The SQL Server is not located on the same machine which has the txt file. So my original question "Does the file exist?" wasn't so stupid afterall :-) http://compnetworking.about.com/od/windowsnetworking/g/unc-name.htmJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
May 11th, 2011 8:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics