SSIS connection manager for ADLS Gen 2 RRS feed

  • Question

  • 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.


    Thursday, August 15, 2019 7:57 PM


  • Hello,

    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.

    Monday, August 19, 2019 9:05 AM