June 19, 2008 at 2:38 pm
I am having a problem with an SSIS package that is trying to do a copy table from Oracle to MS-SQL Server. I think the problem has something to do with the Oracle password not being saved with the package. Is there some configuration option for this? At design time I checked the "Allow saving password".
Message
Executed as user: []. ...cute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:04:47 AM Error: 2008-06-19 11:04:47.84 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-06-19 11:04:50.21 Code: 0xC0202009 Source: Package Connection manager "JDPD.ecm_pd" 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: 2008-06-19 11:04:50.21 Code: 0xC020801C Source: Da. The step failed.
June 23, 2008 at 9:43 pm
SSIS Configurations exist for this sort of purpose. You can configure the properties of various tasks and connections in your package using these - including passwords of course.
Your configuration setting may be stored in several locations - of your choosing. These include the registry, .INI files environment variables and database tables. Personally, most of my configurations are saved to a database table.
To get this happening, select "configuration" from the SSIS menu in BIDS. Hopefully, the wizard you get will be fairly self explanatory.
June 24, 2008 at 8:41 am
when you are setting up your connection thru connection manager check off save password. also on the main page you have an option to save the password with file or on the sql server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply