Error "Failed to decrypt protected XML node.." but the package executed successfully?

• latko

  SSC Rookie

  Points: 35

  More actions

  May 29, 2012 at 8:42 am

  #258792

  Hi guys,

  i am reviewing some jobs that executing SSIS packages. The ssis packages and the jobs are running minimum one month. On the several steps in the job history i saw that the step is executed successfully but in the desc there is a fallowing massage.

  -------------

  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. The package executed successfully. The step succeeded.

  ------------

  I am aware that this is connected with the package ProtectionLevel. My question is: - Is it possible for the package to finish successively and to import the data if there is this massage shown in the job history for the step that is running the package?

  Thanks

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  May 29, 2012 at 1:11 pm

  #1494343

  I would think it is probably possible to complete IF the password (I'm guessing thats the hangup) is set using a config method like files or passed in or something. Honestly I usually set the protection level to save none, I don't like my packages to contain any sensitive data..

  CEWII

• latko

  SSC Rookie

  Points: 35

  More actions

  May 30, 2012 at 3:21 am

  #1494515

  Ok, I tested the package and data is imported, so it seems that the package execution is not affected from this error massage.

  Thanks Elliott for the replay.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  May 31, 2012 at 2:53 pm

  #1495542

  You are welcome.

  CEWII