Ejecutar dtsx desde Job Sql Server RRS feed

  • Pregunta

  • Buenas,

    Estoy intentando ejecutar un paquete dtsx desde un Job en SQL Server 2005, el paquete se ejecuta perfectamente desde SSIS, pero al ejecutarlo desde el Job me da el siguiente error:

    Date 2/11/2013 10:38:09 AM
    Log Job History (My_Job_Name)

    Step ID 1
    Server My_Server
    Job Name My_Job_Name
    Step Name My_Step_Name
    Duration 00:00:05
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Executed as user: My_SQL_Server_User. ...sion 9.00.5000.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:38:10 AM  Error: 2013-02-11 10:38:10.08     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: 2013-02-11 10:38:14.09     Code: 0xC0202009     Source: GenerarDatos Connection manager "My_Connection"     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 Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'My_SA_User'.".  End Error  Error: 2013-02-11 10:38:14.09     Code: 0xC020801C     Source: GenerarDatos...  The package execution fa...  The step failed.

    He probado ejecutar el paquete con varios usuarios y nada me da resultado.

    Les agradecería la ayuda que me puedan brindar.

    lunes, 11 de febrero de 2013 16:49