question

HimanshuSinhamfst-5269 avatar image
1 Vote"
HimanshuSinhamfst-5269 asked ·

SSIS connection manager for ADLS Gen 2

Could we use SSIS with ADLS gen2. I am trying to write file to Azure data lake gen 2 using Azure Blob Upload task and Azure Data Lake Store File System Task, but i am unable to do it.

Thanks.

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]

MSDN Source: SSIS connection manager for ADLS Gen 2


azure-data-lake-storage
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered ·

Welcome to the Microsoft Q&A (Preview) platform.

Happy to answer your query.


Unfortunately, Azure Data Lake Gen2 does not support connecting through SSIS.

Blob storage APIs are disabled to prevent feature operability issues that could arise because Blob Storage APIs aren't yet interoperable with Azure Data Lake Gen2 APIs.

For more details, refer SO thread which addressing similar issue.

Hope this helps.


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.