July 9, 2008 at 3:06 pm
Hi all,
I am using an SSIS package tp pull data from oracle server into SQL.
I can run it successfully from SSIS desiger. But when I try to run it from sql agent, I get the following
error:
Started: 3:00:16 PM
Error: 2008-07-09 15:00:16.31
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: 2008-07-09 15:00:21.02
Code: 0xC0202009
Source: LoadOraTables 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
July 9, 2008 at 3:15 pm
To get around this you can use SSIS configuration files, search this forum and you should be set, or alternativly store the package in SQL and when doing the import from the file system you state that you want to rely on server storage and roles for access control, this is entered at package protection level dialogue.
Andrew
July 9, 2008 at 7:44 pm
use EncryptSensitiveWithUserKey as you Protectionlevel in your SSIS PAckage and also check the username pass in the provider in Dataset.
Also as andrew suggested use configuration file. this will ease things off a bit in terms of changing connection string.
Maninder
www.dbanation.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply