Cannot bulk load because the file error code 3

We specify the storage container as the external data source. I created the external data source with the below T-SQL query:. My new T-SQL query looked like this:. Note that I had configured my Azure blob container access to be Public. If you want to configure your Azure blob container with Private access, you need to create a database scoped credential. Thus, this was my experience with the error Cannot bulk load because the file could not be opened.

The provider did not give any information about the error. Thanks for your suggestion, we found the solution for previous one. The issue was in that end of the text file occupy some empty spaces , so after removing the empty spaces in the text file, it was uploaded successfully. I don't know how to do this with Bulk Insert, because I haven't used that tool in a long time.

I use SSIS instead. If I had to use Bulk Insert, and couldn't find a solution for the extra columns on Google, I would make a staging table that has only the same columns as the text file. SELECT to copy the data from the staging table to the final table, with whatever default values I wanted for the other two columns.

The content you requested has been removed. Ask a question. Improve this question. Solomon Rutzky Jatin Patel Jatin Patel 61 1 1 gold badge 1 1 silver badge 3 3 bronze badges.

Is the bulk load operation within a SSIS package, a bcp routine, or something else? Did you see this question? I know nothing about sql server but that OS error 3 is probably "Path not found". You might want to double check the paths quotes Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1.

Given that: The error occurs when using a file on the network The error does not occur when using a local file local to the server running SQL Server The error does not occur when using a file on the network IF the user logs onto the remote server I would say: Your user is connecting with a Windows Login If the user was connecting with a SQL Server Login, then the behavior would be the same whether they logged into SQL Server from a remote server or from directly on the server via Remote Desktop.

Solomon Rutzky Solomon Rutzky Sign up or log in Sign up using Google. Cannot bulk load because the file could not be opened. Can anyone please help me out. Did you resolve this error Reply. If you put the file on your server folder it will work Reply. Works fine when running inside Azure Data Studio.