x

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.

more ▼

asked Aug 26, 2014 at 02:26 PM in Default

avatar image

sqldev6
1 2 2 4

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.

Aug 26, 2014 at 02:34 PM KenJ

There are no error messages before. This is the first error.

Aug 26, 2014 at 02:36 PM sqldev6

[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

Aug 26, 2014 at 02:38 PM sqldev6
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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)

more ▼

answered Aug 26, 2014 at 02:45 PM

avatar image

KenJ
25k 3 13 20

Awesome.. Thank u soo much for writing this answer here, I checked many other websites but only this was helpful. Thank you :-)

Sep 07, 2016 at 07:45 AM Karuna
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1245
x1208
x788
x34
x23

asked: Aug 26, 2014 at 02:26 PM

Seen: 37471 times

Last Updated: Sep 07, 2016 at 05:23 AM

Copyright 2018 Redgate Software. Privacy Policy