Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS error while executing in command line Expand / Collapse
Author
Message
Posted Friday, August 27, 2010 3:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 10, 2011 5:09 AM
Points: 31, Visits: 54
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.

Post #976253
Posted Friday, August 27, 2010 4:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:47 AM
Points: 199, Visits: 512
Can you check are you able to access the same database using your database engine server type?
Post #976260
Posted Friday, August 27, 2010 4:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 10, 2011 5:09 AM
Points: 31, Visits: 54
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.
Post #976263
Posted Friday, August 27, 2010 4:18 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:47 AM
Points: 199, Visits: 512
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.
Post #976265
Posted Friday, August 27, 2010 4:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 10, 2011 5:09 AM
Points: 31, Visits: 54
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.
Post #976270
Posted Tuesday, September 7, 2010 6:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #981489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse