Read from ADLS gen 2 with SSIS

Question

Does anyone know which connection and Data Flow Component to use for ADLS (Azure Data Lake Store) gen2?

I've managed to use the blob connector in the connection manager and successfully connect to ADLS Gen2, but when I try to use the blob source component I get a 400 bad request. Works fine if it's just a blob storage without HNS.

The ADLS components states it's just for ADLS gen 1.

So how to read and write to/from ADLS Gen 2?

Answer 1

A current version of SSIS Azure Feature Pack supports ADLS Gen2. It can be used as a data source or destination in dataflow:

The screenshot is to show it as a destination, but the ADLSgen2 works well also as a source via corresponding "Flexible File Destination" and "Flexible File Source"