June 25, 2012 at 10:55 am
Hi guys,
i'm having an issue with a package.
I have a controler package that calls a number of other packages that load flat file data into a staging area.
They all use the same data connection, BIStagingConnection.
When I run each individual package, it works, but when I run them from the controller, some fail and some work.
the full error is:
[DST - Staging_Movement_Type [47]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "BIStagingConnection" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I have tryed everything I found on google all to no avail.
Any ideas why and how to solve it?
Ian Cockcroft
MCITP BI Specialist
June 25, 2012 at 11:36 pm
There seems to be some sort of validation error on one of the connections.
Is this the only message that you get? Can you post everything from the output window?
Do you use package configurations?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2012 at 2:00 am
We have had some issues with calling packages from our control package too.
Can you tell us what the value of the property 'ProtectionLevel' is for the package you are calling from your control package (one of the properties of the package itself) ?
Here, this property was causing the issues...
June 26, 2012 at 2:11 am
Setting the Protection Level of Packages
It basically defines the way sensitive data is stored in the packages.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 27, 2012 at 2:55 am
Hi guys, been a bit busy.
I couldnt spend any more time on it.
I re-devd the package to do everything in the controller. It doesnt call any packages.
Not very elegant, but I spent to long trying to sort it out.
when I get a gap, i will go back and try fix it.
thanks for your help.
Ian Cockcroft
MCITP BI Specialist
July 26, 2012 at 2:21 pm
error code: dts_e_cannotacquireconnectionfromconnectionmanager
I kept the "Protection Level" as EncryptSensitivewithUserKey", will it make any problem.
If so, can you tell me what is the level i have to change.
July 27, 2012 at 12:17 am
222.rajkumar (7/26/2012)
error code: dts_e_cannotacquireconnectionfromconnectionmanagerI kept the "Protection Level" as EncryptSensitivewithUserKey", will it make any problem.
If so, can you tell me what is the level i have to change.
It would be helpful if you told us where you executed the package.
If in SQL Server Agent, yes, EncryptSensitiveWithUserKey will make problems.
Change it to EncryptSensitiveWithPassword or DontSaveSensitive and use configurations if necessary.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply