Opening a SQL 2019 SSIS package in Visual Studio gives an Acquire Connection warning

Nick Ryan 261 Reputation points
2023-08-29T23:26:30.19+00:00

This is the text of the warning I get:
Warning loading XXX.dtsx: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "OleDbConnectionManager" failed with error code 0x80004005. Wait 5 seconds to retry.

There appears to be no impact beyond the fact it takes an appreciable amount of time to open any package. Once it's open, the connections are all working fine.

The only thing that's changed is that I've replaced the native client driver SQLNCLI11.1 with the recommended MSOLEDBSQL.1.

This connection is in a variable set from a SQL Server configuration table. The path to the server is set from an XML configuration file. I've replaced the connection string in that file, as well.

I've tried setting Delay validation at the package level and on each of the connections using that driver.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
{count} votes

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.