Post reply

EncryptSensitiveWithPassword in SSIS not prompting for a pasword

  • July 15, 2010 at 2:37 am

    #141315

    I have 2 SSIS Packages. Both of them are set for EncryptSensitiveWithPassword. One of them prompts for the password when opening the package in ssis or importing it to Integration Services. This allows me to pass a password when running the package from a command line.

    I have set the same EncryptSensitiveWithPassword setting in the second package but it will not prompt me for a password. This is preventing me from executing the package using a command line.

    My question is, “When using EncryptSensitiveWithPassword how do I force the package to always prompt for the password?”

    Thanks for any help.

  • July 15, 2010 at 4:29 pm

    #1193825

    Hi Darren

    Have you tried to change the security first back to default run it and reset it back again and check if it works...

    also keep different passwords for each package

    not sure if they help but a thought any way

    gud luk

  • July 16, 2010 at 2:22 am

    #1193928

    Thanks Vani_r14

    I changed the security level back to EncryprSensitiveWithUserKey saved the package then changed it back to EncryptSensitiveWithPassword "But did not enter the password" then made a change and saved the package. This caused the package to error while doing the save and force me to enter the password.

    The package now prompts me for a password and works as it should.

    Thanks agian

    Darren

  • July 20, 2010 at 3:57 pm

    #1195841

    Hei

    Gr8 it worked .... YAY 🙂 🙂

    cheers

    Vani

  • July 21, 2010 at 7:22 am

    #1196145

    Is there a reason why you didn't use SQL Security and let that control the execution of your package?

Viewing 5 posts - 1 through 4 (of 4 total)

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