InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:24:20 GMT20http://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxthanks Brian, worked like a charmWed, 04 Jan 2012 15:56:47 GMTAlan Richmondhttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxThanks Brain that really helped.Tue, 14 Dec 2010 07:42:26 GMTpranethpallahttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxThat resolved it for me but it really doesn't make sense why it works. Any clues? All I know is it's resolved and I'm ahppyTue, 19 Jan 2010 09:47:45 GMTadam.plagerhttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxI got the same error and tried different options for protectionlevel but failed with same error.i tried serverproperty and dont save sensitive but still failed.Fri, 14 Aug 2009 19:52:15 GMTTara-1044200http://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxThanks for your soon answer Brian, I will do it and if I got an error I will let you know.Regards,MiguelFri, 10 Oct 2008 10:25:31 GMTmoguelhttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxThis is a common problem where the job doesn't have the rights to run the package. The default property for a package is EncryptSensitivewithUserKey for the ProtectionLevel property. Ideally, you should set that to EncryptAllwithPassword and pass the password into the package.Thu, 09 Oct 2008 09:52:46 GMTBrian Knighthttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxI got this message, does someone face this kinf of issue, I think I need more permission.MessageExecuted as user: ServerName\SYSTEM. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:54:31 AM Error: 2008-10-09 09:54:32.55 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: 2008-10-09 09:54:35.28 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "PackagePassword" 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: 2008-10-09 09:54:35.28 Code: 0xC0016016 Source: Description: Failed ... The package execution fa... The step failed.Thu, 09 Oct 2008 08:57:15 GMTmoguelhttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxNice :):)Thu, 09 Oct 2008 01:45:18 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic583090-31-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Video/64388/">Scheduling SSIS Packages - SQL School Video</A>[/B]Thu, 09 Oct 2008 01:06:24 GMTBrian Knight