title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | ||
---|---|---|---|---|---|---|---|---|---|---|
Azure Blob Source |
Azure Blob Source |
chugugrace |
chugu |
08/20/2018 |
sql |
integration-services |
how-to |
|
[!INCLUDEsqlserver-ssis]
The Azure Blob Source component enables an SSIS package to read data from an Azure blob. The supported file formats are: CSV and AVRO.
To see the editor for the Azure Blob Source, drag and drop Azure Blob Source on the data flow designer and double-click it to open the editor).
The Azure Blob Source is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.
-
For the Azure storage connection manager field, specify an existing Azure Storage Connection Manager or create a new one that refers to an Azure Storage Account.
-
For the Blob container name field, specify the name of the blob container that contains source files.
-
For the Blob name field, specify the path for the blob.
-
For the Blob file format field, select the blob format you want to use, Text or Avro.
-
If the file format is Text, you must specify the Column delimiter character value. (Multi-character delimiters are not supported.)
Also select Column names in the first data row if the first row in the file contains column names.
-
If the file is compressed, select Decompress the file.
-
If the file is compressed, select the Compression type: GZIP, DEFLATE, or BZIP2. Note that the Zip format is not supported.
-
After you specify the connection information, switch to the Columns page to map source columns to destination columns for the SSIS data flow.