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

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

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

Try renaming your file to Document.txtJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

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.).".

hi sharath 048 i think you are in client machine u just move the file into server and do same....... thanks nathan

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

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?

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