![]() My new T-SQL query looked like this: BULK INSERT. Then click the X that appears on the left upper corner of BorderTool 2 to perform the uninstall. Click and hold BorderTool 2 icon with your mouse button until it starts to wiggle. Open up Launchpad, and type BorderTool 2 in the search box on the top. In the above code, MyExternalSource is the external data source name, in the LOCATION parameter, we will specify the link to our Azure blob container, where sqlserverbackupdb is the name of my Azure blob container.Īfter following the above steps, I was able to use the BULK INSERT statement along with a CSV file. Option 2: Delete BorderTool 2 in the Launchpad. I created the external data source with the below T-SQL query: CREATE EXTERNAL DATA SOURCE MyExternalSource We specify the storage container as the external data source. Then upload the CSV file to the storage container.Īfter that, we need to create an external data source in our Azure SQL database. The idea is to create a storage account and create a storage container. If you do not know how to create a storage container in Azure, you can read our article on Backup and restore SQL server to Azure blob storage. But for this, I needed to create a storage account in Microsoft Azure. Luckily, I found an alternative way to do it. I did some research on this error and found that the Azure SQL database does not support reading files from the local file system. cannot bulk load because the file could not be opened. I checked the location of my CSV file again, but everything was fine (If the file is not available in the specified path, you may face this error). I understood from the error that my file was not being read. I was using SQL Server management studio so that I could upload a file from my local storage.Ĭannot bulk load because the file could not be opened. Error: Cannot bulk load because the file “C:\Users\Blades\Documents\test.csv” could not be opened. Then I faced the error Failed to execute query. įROM 'C:\Users\Blades\Documents\test.csv' ![]() Below is the code that I was trying to execute: BULK INSERT. It was a CSV file that I was trying to upload. I was trying to bulk insert data from my local storage into the Azure SQL database. Recently, when I was working with the BULK INSERT statement in the Azure SQL database, I faced an error. operating system error code (null)Ĭannot bulk load because the file could not be opened. cannot bulk load because the file could not be opened.Cannot bulk load because the file could not be opened. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |