August 27, 2010 at 3:54 am
Hi,
I developed a SSIS 2008 package to read from DB2 (using some id) into SQL server (using windows authenication). I face error when trying to execute, once I open and test connection for DB2 it works fine. But when tried to schedule via config xml file in a batch progam i am facing 'cannot acquire connection'
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Stored_Src" failed with error code 0xC0202009.
Any help.
August 27, 2010 at 4:07 am
Can you check are you able to access the same database using your database engine server type?
August 27, 2010 at 4:10 am
I didn't get you. Can u explain in detail.
Once I close my package and try to open again in VS also I am gettin the same error (Cannot acquire connection) though I give save password option.
August 27, 2010 at 4:18 am
ohh... try the below one. It may help!
Go to Package Properties --> In Security Tab Choose Protection Level --> Then select the option "EncryptSensitiveWithUserKey" --> Save it and run the Package.
August 27, 2010 at 4:29 am
No it didn't work.
Even in VS in control flow I am getting this error (Red x mark for data flow connecting to DB2) but able to execute succesfully in VS without config file. Error occurs while runing in command line using config file.
September 7, 2010 at 6:15 am
Hi,
This might Help....
http://support.microsoft.com/kb/918760
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply