Download and install the SSIS Productivity Pack
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
Hope it helps..