| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Connect to Azure Blob Storage (SQL Server Import and Export Wizard) |
Connect to Azure Blob Storage (SQL Server Import and Export Wizard) |
chugugrace |
chugu |
02/17/2017 |
sql |
integration-services |
conceptual |
[!INCLUDEsqlserver-ssis]
This topic shows you how to connect to an Azure Blob Storage data source from the Choose a Data Source or Choose a Destination page of the SQL Server Import and Export Wizard.
Note
To use the Azure Blob Source or Destination, you have to install the Azure Feature Pack for SQL Server Integration Services.
-
To download the Feature Pack, see Microsoft SQL Server 2016 Integration Services Feature Pack for Azure.
-
For more info, see Azure Feature Pack for Integration Services (SSIS).
The following screen shot shows the options to configure for a connection to Azure Blob Storage.
Note
The connection options for this data provider are the same whether Azure Blob Storage is your source or your destination. That is, the options you see are the same on both the Choose a Data Source and the Choose a Destination pages of the wizard.
Use Azure account
Specify whether to use an online account.
Storage account name
Enter the name of the Azure storage account.
Account key
Enter the key for the Azure storage account.
Use HTTPS
Specify whether to use HTTP or HTTPS to connect to the storage account.
Use local developer account
Specify whether to use the Azure Storage Emulator on the local computer.
Blob container name
Select from the list of storage containers available in the specified storage account.
Blob file format
Select Text or Avro file format.
Column delimiter character
If you selected Text format, enter the column delimiter character.
Use first row as column names
Specify whether the first row of data contains column names.