• I have the Package deployed by following steps

    -->Right Click on Project and Deployment utility is set to true

    -->Build the Solution

    -->Go to bin\Deployment and run the deployment tool and selected file system type.

    -->Scheduled the package in SQL Server Jobs .

    But i was getting the following error ..My Question is where the packages encrypted?? The package level protection is as "EncryptSensitiveWithUserKey"

    Message

    Executed as user: XX\ACXXXX. ...Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 4:22:33 PM Error: 2011-08-23 16:22:33.84 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-08-23 16:22:33.86 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error