Post reply

SSIS Package Execute Error

  • October 26, 2006 at 9:02 pm

    #153260

    While executing packages in a file from a procedure, I get error:

     

    Error: 2006-10-24 14:58:54.62

    Code: 0xC0016016

    Source: 

    Description: Failed to decrypt protected XML node "DTSassword" 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

    Please let me know how to solve this error.

  • October 27, 2006 at 11:27 am

    #668576

    Try this:

    In the package properties, go to Security/ProtectionLevel and select EncryptSensitiveWithPassword.  Then enter a password above that in PackagePassword.  You will need to pass the password in when you run the package (eg: dtexec /FILE filename /De password).  Hope that helps.

    Kindest Regards,

    JimAtWork

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

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