Adding encrypted password to SSIS package renders unopenable to future editing

  • Attempting to open SSIS application that uses a password on a database connection. To get the thing to work, the password needs to be applied to the entire application. Now I need to make changes to the package but am unable to open it. Error is thrown stating the password I entered cannot be decrypted or is incorrect.

    The application of passwords in SSIS package components is a kludge to begin with but this is ridiculous.

  • Answer...Because one of your colleagues changed the password....Doh!!!

    (...and didn't tell the boss!!!)

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

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