encrypting and decrypting passwords in SSIS RRS feed

  • Question

  •   Below is the high level steps for encrypting and decrypting passwords in SSIS,
    1. Store the Password in encrypted format in data setup table
    2. Define a SSIS Variable called “EncryptionKey” in package level
    3. Use Execute SQL Task , Get the encrypted value from database and store the value in this “EncryptionKey”.
    4. Use Script component to decrypt the password from the SSIS Variable “EncryptionKey” and pass this value (Dynamically) to the connection string property of connection manager.

    Please help me how to accomplish the above tasks.

    Tuesday, March 27, 2012 4:04 AM


All replies