- Thank you received: 0
Error code 0xC0202009 when deploying a SSIS package
- Dmitro Babko
- Topic Author
- Offline
- User
-
Less
More
1 month 3 weeks ago #14775
by Dmitro Babko
Error code 0xC0202009 when deploying a SSIS package was created by Dmitro Babko
Hello.
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?
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 month 3 weeks ago #14777
by admin
Replied by admin on topic Error code 0xC0202009 when deploying a SSIS package
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.141 seconds