Link to home
Start Free TrialLog in
Avatar of rauljimenez
rauljimenezFlag for Spain

asked on

error job with ssis package

I set a package in ssis with my user, i save copy as package as.... a file , and set  in proteccion level : do not save sensitive.
After i make a job sqlserver agent, with this package, but to execute give the follow error:

Executed as user: *****\Administrador. ...00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  14:25:43  Error: 2011-09-16 14:25:44.41     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Clave no válida para utilizar en el estado especificado.". 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: 2011-09-16 14:25:48.16     Code: 0xC0202009     Source: analisis_planta Connection manager "xxxxxxx.AX40_SP2.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 Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'sa'.".  End Error  Error: 2011-09-16 14:25:48.16     Code: 0xC020801C     Sour...  The package execution fa...  The step failed.

is a problem of access right?
ASKER CERTIFIED SOLUTION
Avatar of Ramesh Babu Vavilla
Ramesh Babu Vavilla
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial