August 22, 2011 at 1:50 pm
Hello everyone,
I came across a issue today related to SSIS that has never seen y me so hopefully some one form might have a solution for this.
I have SSIS packages running on the server that use configuration files for connections.
for some reason last week the packages start failing with the error
"SIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER"
we tried many thing but didn't work finally i just restarted the SSIS services again and every thing worked fine.
now today the same issues came again, i applied the same solution and it worked.
what could be the long term solution to this so the packages wont fail.
what the reason that the connection to the configuration file gets broken down and a restart of the services corrects it.
and how can fix it so the packages wont fail.
Hope some one can help me.
August 23, 2011 at 9:44 am
Guys, even if no one has a exact answer, some idea would be nice
August 24, 2011 at 7:29 am
Are you sure it is the connection to the configuration that breaks down?
Do you get any configuration errors/warnings?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2011 at 7:44 am
Thanks for the response,
The reason I think is the connection to the configuration file is because of two things,
i get the following error
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "********"
failed with error code 0xC0202009.
second the reset corrects that.
Hope it helps
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply