SQL Server Integration Services and Azure Data Lake Store Connection Manager

Leonardo Bruno Pereira de Araujo 0 Reputation points
2024-09-18T14:52:20.88+00:00

Is it possible a SQL Server Integration Services (SSIS) package can use the Azure Data Lake Store Connection Manager to connect to an Azure Data Lake Storage Gen2 ??

From what I read the article below refers only for Gen 1 but and about the Gen 2?

Link for reference: https://video2.skills-academy.com/en-us/sql/integration-services/connection-manager/azure-data-lake-store-connection-manager?view=sql-server-ver16

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,466 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,568 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 36,116 Reputation points
    2024-09-19T02:03:37.99+00:00

    Hi @Leonardo Bruno Pereira de Araujo,

    I installed Microsoft SQL Server 2022 Integration Services Feature Pack for Azure and when i use Azure Blob Source Editor, i can create the manager connection for Gen2.

    You may have a double check.

    User's image Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

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.