May 31, 2015 at 10:19 pm
Hi,
I have a Master Package that controls the execution of the SSIS packages, each time i execute the master some of the connections break in the sub packages during the execution with the following error:
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "MDM" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
If packages are executed individually then most of the time they succeed but do fail sometime. With the master package they fail a lot. Its a random behavior, and one component fails one time and succeed the next time. All the times it happens with Lookup, Source and Destination components.
I am running the packages from SSDT. Even tried running them through Integration Services Catalog but still same problem.
Some of the package configurations i am using are:
ProtectionLevel = EncryptSensitiveWithUserKey
DelayValidation = False
Any one had a similar experience earlier?
Best regards,
Moid ul Hassan
June 1, 2015 at 12:00 pm
A few questions to narrow it down:
How are you setting the values of your connection strings?
Is logging enabled?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply