SSIS job scheduled failed to connect to Azure Data Warehouse

Aurnorakarnkij, Sanit 0 Reputation points
2026-08-18T06:54:12.76+00:00

Previously, we are able to run SSIS jobs to retrieve data from Azure Data Warehouse. We are migrating to a New Server. It is fine to connect through SSMS or run the SSIS package in Visual Studio on this new server. However, running the SSIS jobs failed to connect to Azure. The error is "Data Flow CRS:Error: ADO NET Source has failed to acquire the connection {2C0B0490-8582-4EF0-B072-F49FFAB6A861} with the following error message: "One or more errors occurred.". Try using other connection provider got this error "Data Flow CRS:Error: ADO NET Source has failed to acquire the connection {6C6EEFC8-89D2-4EDA-8A2D-2DCA957719E5} with the following error message: "Could not create a managed connection manager.". " The authentication is Microsoft Entra Integrated.

SQL Server Integration Services
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 27,196 Reputation points
    2026-08-18T18:34:59.5833333+00:00

    Hi @Aurnorakarnkij, Sanit,

    Also, the Microsoft OLE DB Driver for SQL Server is very performant.

    Was this answer helpful?

    0 comments

Your answer

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