Error code 0xC0202009 when deploying a SSIS package

  • Dmitro Babko
  • Topic Author
  • Offline
  • User
  • User
1 year 5 months ago #14775 by Dmitro Babko

I am creating a package in Visual Studio 2019 with an OLE DB connection with the PGNP.1 provider.

When the connection is created, the connection test succeeds.

After running the package, I get the error:
[Source "OLE DB" [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "my connection address" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

When I reopen the connection in Connection Managers and click the Test Connection button, I get a new error:
The connection check failed due to an error initializing the provider. The value is not in the expected range.

I see that the password is not stored in the connection string, or what am I doing wrong?

Please Log in or Create an account to join the conversation.

1 year 5 months ago #14777 by admin
Yes, missing password could be one of the reasons. I would recommend collecting trace in PGNProfiler in order to see additional details about reason of the issue (launch as Admin and click button in toolbar to start capture).

Please Log in or Create an account to join the conversation.

Time to create page: 0.131 seconds
Powered by Kunena Forum