Skip to content

azure-blob-source.md

Latest commit

 

History

History
43 lines (27 loc) · 1.93 KB

azure-blob-source.md

File metadata and controls

43 lines (27 loc) · 1.93 KB
title Azure Blob Source
description Azure Blob Source
author chugugrace
ms.author chugu
ms.date 08/20/2018
ms.service sql
ms.subservice integration-services
ms.topic how-to
f1_keywords
sql13.dts.designer.afpblobsrc.f1
sql14.dts.designer.afpblobsrc.f1

Azure Blob Source

[!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.

  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.