Azure Data Lake Storage Component in KingswaySoft – SSIS

Download and install the SSIS Productivity Pack

https://www.kingswaysoft.com/products/ssis-productivity-pack/download/

Drag the Azure Data Lake Storage Source component in the data flow

Double click and click on New to specify the connection

Provide the connection details and test the connection

• It supports both Gen 1 and Gen 2

• Supports the below Authentication modes

Inside the Azure Data Lake Storage Source component, we have specified our CSV file.

• All Contact.csv file

Item Selection Mode:

• Selected Item: Retrieves only the item specified by Source Item Path.
• Selected Level: Retrieves the selected item and all immediate files and folders under the path specified by the Source Item Path option.
• Selected Level (Files only): Retrieves the selected item and all immediate files under the folder as specified by the Source Item Path option.
• Recursive: Retrieves the selected item (specified by the Source Item Path option) and all sub items recursively.
• Recursive (Files only): Retrieves items the same as the Recursive mode but only returns files.

The page size refers to how many records to retrieve per service call

The columns page shows all the available attributes from the object specified in the General page

We have used the script component as the destination to read the values of all the above columns

The value for each of the columns –

Get all the details here

https://www.kingswaysoft.com/products/ssis-productivity-pack/help-manual/cloud-storage

https://nishantrana.me/2020/12/10/posts-on-azure-data-lake/

Hope it helps..

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology ! View all posts by Nishant Rana