Azure Blob Source

APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

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.

  1. 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.

  2. For the Blob container name field, specify the name of the blob container that contains source files.

  3. For the Blob name field, specify the path for the blob.

  4. For the Blob file format field, select the blob format you want to use, Text or Avro.

  5. 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.

  6. If the file is compressed, select Decompress the file.

  7. If the file is compressed, select the Compression type: GZIP, DEFLATE, or BZIP2. Note that the Zip format is not supported.

  8. After you specify the connection information, switch to the Columns page to map source columns to destination columns for the SSIS data flow.