Azure Data Lake Store Source

  • Article

The Azure Data Lake Store Source component enables an SSIS package to read data from an Azure Data Lake Store. The supported file formats are: Text and Avro.

Configure the Azure Data Lake Store Source

  1. To see the editor for the Azure Data Lake Store Source, drag and drop Azure Data Lake Store Source on the data flow designer and double-click it to open the editor).

  2. For the Azure Data Lake Store connection manager field, specify an existing Azure Data Lake Store Connection Manager or create a new one that refers to an Azure Data Lake Store service.

    1. For the File Path field, specify the file path of the source file in Azure Data Lake Store.

    2. For the File format field, specify the file format of the source file.

      If the file format is Text, you must specify the Column delimiter character value. Also select Column names in the first data row if the first row in the file contains column names.

  3. After specifying the connection information, switch to the Columns page to map source columns to destination columns for the SSIS data flow.