Share via

SSIS connection manager for ADLS Gen 2

HimanshuSinha-msft 601 Reputation points
2020-05-08T22:49:51.74+00:00

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
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,492 questions
0 comments
Accepted answer
  1. KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee
    2020-05-08T22:58:07.997+00:00

    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.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.