title: How to RUN Scheduled Task in SQL Server 2008 for SSIS Package?
body: <p>I am trying to run an <code>SSIS</code> package in SQL Server Agent, and create job successfully, but when I try to run, I got this error:</p>
  
  <blockquote>
    <p>Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1
    for 32-bit Copyright (C) Microsoft Corporation 2010. All rights
    reserved.</p>
    
    <p>Started:  9:09:23 AM Error: 2015-02-17 09:09:23.77    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: 2015-02-17
    09:09:24.57    Code: 0xC0202009    Source: Package Connection manager
    "localhost.Sample.sa"    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: 2015-02-17 09:09:24.58<br>
    Code: 0xC020801C    Source: Data OLE DB Source [1]    Description:
    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. 
    The AcquireConnection method call to the connection manager
    "localhost.Sample.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: 2015-02-17
    09:09:24.58    Code: 0xC0047017    Source: Data SSIS.Pipeline<br>
    Description: component "OLE DB Source" (1) failed validation and
    returned error code 0xC020801C. End Error Error: 2015-02-17
    09:09:24.58    Code: 0xC004700C    Source: Data SSIS.Pipeline<br>
    Description: One or more component failed validation. End Error Error:
    2015-02-17 09:09:24.59    Code: 0xC0024107    Source: Data<br>
    Description: There were errors during task validation. End Error
    DTExec: The package execution returned DTSER_FAILURE (1). Started: 
    9:09:23 AM Finished: 9:09:24 AM Elapsed:  0.905 seconds Microsoft (R)
    SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit
    Copyright (C) Microsoft Corporation 2010. All rights reserved.</p>
    
    <p>Started:  9:14:47 AM Error: 2015-02-17 09:14:47.66    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: 2015-02-17
    09:14:47.94    Code: 0xC0202009    Source: Package Connection manager
    "localhost.Sample.sa1"    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: 2015-02-17 09:14:47.94<br>
    Code: 0xC020801C    Source: Data Flow Task OLE DB Source [1]<br>
    Description: SSIS Error Code
    DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The
    AcquireConnection method call to the connection manager
    "localhost.Sample.sa1" 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: 2015-02-17
    09:14:47.94    Code: 0xC0047017    Source: Data Flow Task
    SSIS.Pipeline    Description: component "OLE DB Source" (1) failed
    validation and returned error code 0xC020801C. End Error Error:
    2015-02-17 09:14:47.94    Code: 0xC004700C    Source: Data Flow Task
    SSIS.Pipeline    Description: One or more component failed validation.
    End Error Error: 2015-02-17 09:14:47.94    Code: 0xC0024107    Source:
    Data Flow Task     Description: There were errors during task
    validation. End Error DTExec: The package execution returned
    DTSER_FAILURE (1). Started:  9:14:47 AM Finished: 9:14:47 AM Elapsed: 
    0.359 seconds</p>
  </blockquote>