title: SSIS Package Failing on Executing Job
body: <p>Good Day,</p>
  
  <p>I imported a package from SSIS to SQL to run as a Job.
  if i manually execute the Package in SSIS in MSSMS it executes successful
  as soon as i run it as a job i get the following error:</p>
  
  <blockquote>
    <p>Executed as user: NT AUTHORITY\LOCAL SERVICE. Microsoft (R) SQL Server
    Execute Package Utility  Version 10.50.1600.1 for 64-bit  Copyright
    (C) Microsoft Corporation 2010. All rights reserved.    Started: 
    12:10:22 PM  Error: 2014-08-14 12:10:22.07     Code: 0xC0016016<br>
    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:
    2014-08-14 12:10:22.24     Code: 0xC0202009     Source:
    TritonFuelImport Connection manager "41.160.218.141.CCManager.sa"<br>
    Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has
    occurred. Error code: 0x80040E4D.  An OLE DB record is available. 
    Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E4D
    Description: "Login failed for user 'sa'.".  End Error  Error:
    2014-08-14 12:10:22.24     Code: 0xC020801C     Source: Data Flow Task
    OLE DB Destination [15]     Description: SSIS Error Code
    DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The
    AcquireConnection method call to the connection manager
    "41.160.218.141.CCManager.sa" failed with error code 0xC0202009. 
    There may be error messages posted before this with more information
    on why the AcquireConnection method call failed.  End Error  Error:
    2014-08-14 12:10:22.24     Code: 0xC0047017     Source: Data Flow Task
    SSIS.Pipeline     Description: component "OLE DB Destination" (15)
    failed validation and returned error code 0xC020801C.  End Error 
    Error: 2014-08-14 12:10:22.24     Code: 0xC004700C     Source: Data
    Flow Task SSIS.Pipeline     Description: One or more component failed
    validation.  End Error  Error: 2014-08-14 12:10:22.24     Code:
    0xC0024107     Source: Data Flow Task      Description: There were
    errors during task validation.  End Error  DTExec: The package
    execution returned DTSER_FAILURE (1).  Started:  12:10:22 PM 
    Finished: 12:10:22 PM  Elapsed:  0.187 seconds.  The package execution
    failed.  The step failed.</p>
  </blockquote>
  
  <p>Can someone Please assist to help me solve this problem?</p>