ADLS gen 2 with SSIS

Category: azure data lake


JanKolodziejczyk on Tue, 19 Feb 2019 10:00:15

Is it possible to use SSIS with ADLS 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.

Is SSIS not compatible with ADLS gen 2, or is there a trick I'm missing?


CHEEKATLAPRADEEP-MSFT on Wed, 20 Feb 2019 06:51:01


Your query has been addressed on StackOverflow. If you have any further query do let us know.

CHEEKATLAPRADEEP-MSFT on Fri, 22 Feb 2019 08:47:41

Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know.