Home Forums SQL Server 2008 SQL Server 2008 - General SSIS package fails in the scheduled job- How to add Decrypt password in command line - Any Example syntax please RE: SSIS package fails in the scheduled job- How to add Decrypt password in command line - Any Example syntax please

  • August 1, 2012 at 11:25 pm

    #1520643

    Sqlism (8/1/2012)

    I changed the protection level to EncryptSensitiveWithPassword

    Please let me know syntax to "add /decrypt with the password"

    Thanks a ton!

    As I said before, SQL Agent will ask you for the password. Normally you don't have to edit the command line in a job yourself. Also, I linked to the syntax defination at the bottom of my post.

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