SSIS connection manager for ADLS Gen 2

HimanshuSinha-msft 601 Reputation points

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.


[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.
993 questions
0 comments No comments
{count} vote

Accepted answer
  1. KranthiPakala-MSFT 39,007 Reputation points Microsoft Employee

    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 No comments

0 additional answers

Sort by: Most helpful