SSIS error while executing in command line

  • 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.

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

  • 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.

  • 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.

  • 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.

  • 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