Job Execution

Posted on 2009-02-24
Medium Priority
Last Modified: 2013-12-12
I keep getting this error anytime i try to excute a job to run an SSIS package, can anyone tell me what im doing wrong?

Executed as userXXX\sqlservice. ...ion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:07:16  Error: 2009-02-24 12:07:16.56     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: 2009-02-24 12:07:17.11     Code: 0xC0202009     Source: refresh_style_colour_dims Connection manager "SourceConnectionOLEDB"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Oracle"  Hresult: 0x80040E4D  Description: "ORA-01017: invalid username/password; logon denied  ".  End Error  Error: 2009-02-24 12:07:17.11     Cod...  The package execution fa...  The step failed.
Question by:M_Boy76

Expert Comment

ID: 23720651
its purely invalid username/password; better try to reolve the username

Author Comment

ID: 23720692
is it the account used to login into the other system or the account used to run the job?
LVL 60

Accepted Solution

chapmandew earned 1000 total points
ID: 23720922
you may have to go into the package, and set the passwordencryption option to "do not save"
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  


Author Comment

ID: 23723438
How do i do that?
LVL 30

Assisted Solution

nmcdermaid earned 1000 total points
ID: 23729896
Right click on a blank spot in the designer and press properties.
In the properties pane, go to Security/ProtectionLevel
You probably have 'EncryptSensitiveWithUserKey' selected.
When the developer account (yourself) doesn't match the execution account (sql agent), it cant find the key to decrypt passwords.
There is a whole topic around package protection levels, but here are some solutions:
1. Only use trusted connections in your package, and pick a protection level of DontSaveSensitive
2. If you must use passwords in your package (i.e. if you have an AS400 source), pick EncryptSensitiveWithPassword and enter a password. Then use that password when scheduling it.
LVL 60

Expert Comment

ID: 23729937
thank you nmcdermaid, I accidentally skipped over this response.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Rules and regulations were devised in order to maintain the integrity of a system. However, interpretation of rules can be quite tricky.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question