Cannot acquire connection from connection manager

  • 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 post 1 (of 2 total)

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