SSIS error while executing in command line

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS error while executing in command line

SSIS error while executing in command line

Rate Topic

Display Mode

Topic Options

Author

Message

Aarathy

Posted Friday, August 27, 2010 3:54 AM

SSC 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

sqlusers

Posted Friday, August 27, 2010 4:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 195, Visits: 463

Can you check are you able to access the same database using your database engine server type?

Post #976260

Aarathy

Posted Friday, August 27, 2010 4:10 AM

SSC 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

sqlusers

Posted Friday, August 27, 2010 4:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 195, Visits: 463

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

Aarathy

Posted Friday, August 27, 2010 4:28 AM

SSC 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

H4K

Posted Tuesday, September 07, 2010 6:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

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 »

Permissions