title: SSIS: Just started getting a "Key not valid for use in specified state." error on my scheduled SSIS package
body: <p>I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM).  These jobs have worked fine (mostly) for years and although I've had a few hiccups that I've had to work through this problem is completely stumping me.</p>
  
  <p>Two mornings ago, one of my packages started reporting the following error:</p>
  
  <pre><code>Executed as user: [Service Acount]. ...n 9.00.4035.00 for 32-bit
  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
       Started:  1:15:01 AM  Error: 2012-10-17 01:15:03.98
       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: 2012-10-17 01:15:03.99
       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: 2012-10-17 01:15:04.01
       Code: 0xC0016016     
  Source:       
  Description: Failed to ...  The package execution fa...  The step failed.
  </code></pre>
  
  <p>This appears to be a common problem, however, none of the recommendations that I've found either apply to my scenario nor does my instance seem to match most of the other cases where this occurs.  Here are the important details regarding my implementation.</p>
  
  <ul>
  <li>This package is exporting data from an iSeries system, to SQL Server
  2005 data tables. </li>
  <li>This process works successfully but keeps crashing
  on one, specific table export.  In fact, it runs without any trouble
  for over 2 hours before it dies.  After inspecting all properties associated
  with this step, I can see that there is nothing different about this step 
  compared to the other table export steps, other than the table/column export 
  mappings.</li>
  <li>The package <code>ProtectionLevel</code> is set to <code>DontSaveSensitive</code> and the iSeries 
  credentials are stored in a config file that is accessed by SQL Server. </li>
  <li>I can execute the failing step on my machine, in BIDS. Regardless, it doesn't 
  work on the server, though the server is using the exact same credentials.</li>
  <li>As I mentioned, I have two packages.  They are effectively the same thing, except 
  one is exporting the data from one iSeries database, and the other is exporting 
  data that is almost the exact same structure from another iSeries DB.  The first 
  package doesn't have any trouble even though it is using the same iSeries credentials.</li>
  <li>To be clear, nothing on my server has changed in months (that I am aware of.)  This 
  just started happening yesterday morning.</li>
  </ul>
  
  <p>Any tips, or thoughts would be tremendously helpful.  This export is extremely important and many users/worker rely on this data for their day-to-day work.</p>