Skip to main content
IN PREVIEW

Load files from Azure Blob storage into Azure SQL Database

Published date: October 23, 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.

  • Features