Load files from Azure Blob storage into Azure SQL Database
23 October 2017
Azure SQL Database will enable you to directly load files stored in Azure Blob storage by using the following SQL statements:
· BULK INSERT T-SQL—command that will load a file from a Blob storage account into a SQL Database table
· OPENROWSET table—value function that will parse a file stored in Blob storage and return the content of the file as a set of rows
For examples of code that will load the content of files from an Azure Blob Storage account, see SQL Server GitHub samples. For more information, please visit the Loading files from Azure Blob storage into Azure SQL Database webpage.