Post reply

Cannot acquire connection from connection manager

  • January 16, 2011 at 8:12 pm

    #144799

    Hi Guys,

    I am facing a situation where I am calling a SSIS package from another SSIS package using Execute Process Task, it throws "cannot acquire connection from connection manager" error. The task is created with relevant package and passord details

    If I ran the child SSIS package, it runs successfully. The protectionlevel property of child SSIS package is set to "EncryptSensitiveWithPassword".

    Any help would be appreciated.

  • January 17, 2011 at 2:04 am

    #1274136

    I guess you are trying to connect with SQL Server authentication, right?

    How do you input the password into the Execute Process Task?

    Isn't it easier to use the Execute Package Task? (that's why it is there, after all :-))

    The editor there has a special input box for the password.

    Also make sure that the protection level of the parent package is set correctly, so that the password (which is sensitive data) is remained during execution or after the package has been closed.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply