SSIS Error Code DTS_E_CANNOT ACQUIRECONNECTIONFROMCONNECTIONMANAGER. The Acquire connection method call to the connectionmanager failed with error code 0xC0014009.

Question

I have created a project have multiple packages. Using ODBC as source and OLE DB as a destination. It is working fine in Visual Studio but when I've deployed it on SSMS to schedule it when I'm executing it manually from SSMS it's not executing so the job is also failing with the error like
SSIS Error Code DTS_E_CANNOT ACQUIRECONNECTIONFROMCONNECTIONMANAGER. The Acquire connection method call to the connectionmanager failed with error code 0xC0014009.

I have tried 32bit runtime, delay validation.

To test it I have created another package with flat file source it's also not executing from SSMS giving error like
Data flow task 1: Error : flat file source failed the preexecute phase and returned error code 0xc020200E
SQL Server instance I'm connecting from SSMS is intalled on another server.

Answer 1

Hi @Anonymous ,

It may have failed as follows:

•The user account that is used to run the package under SQL Server Agent differs from the original package author.

•The user account does not have the required permissions to make connections or to access resources outside the SSIS package.

Have you tried to use Proxy Account to Execute a Package?

Details you may refer:

ssis-package-doesnt-run-when-called-job-step

ssis-using-proxy-account-to-execute-a-package.aspx

Regards，

Zoe

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

Hi @Anonymous ,

Please try to connect to the SSIS run-time server via Remote Desktop (RDP), and try to execute SSIS packages locally in SSMS on that server.