question

sqldev6 avatar image
sqldev6 asked

Error code 0xC0202009 in SSIS

Hi, I created SSIS package which takes data from all production servers and insert that to repository. When I try to run package, it is running for few and then it is showing following error. [OLE DB Source [61]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Dynamic_SQLServerConn" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
sqlssissql-server-2008-r2ssis errorssis-2008
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
Were there any other error messages - "There may be error messages posted before this with more information on why the AcquireConnection method call failed" If you could include the package output in its entirety, that would be helpful.
0 Likes 0 ·
sqldev6 avatar image sqldev6 commented ·
There are no error messages before. This is the first error.
0 Likes 0 ·
sqldev6 avatar image sqldev6 commented ·
[OLE DB Source [61]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Dynamic_SQLServerConn" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [SSIS.Pipeline] Error: OLE DB Source failed validation and returned error code 0xC020801C. Progress: Validating - 100 percent complete [SSIS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. Finished, 9:34:28 AM, Elapsed time: 00:00:00.250
0 Likes 0 ·

1 Answer

·
KenJ avatar image
KenJ answered
If you are setting the connection dynamically then it probably isn't valid at package startup since it hasn't been assigned the dynamic value. Set the delay validation property to True and see if that fixes it up (right-click the design surface and select properties)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Karuna avatar image Karuna commented ·
Awesome.. Thank u soo much for writing this answer here, I checked many other websites but only this was helpful. Thank you :-)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.