OLEDB provider for Oracle - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

OLEDB provider for Oracle

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-09-08 : 05:38:49

Dear All,

I am using Connection manager of Native OLEDB/Microsoft OLEDB provider for Oracle where i am saving credentials user name and password with save password check box checked.

But when i running the job from the Job agent its failing with error says
"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."

Could u please help me to save password.

Thanks,
Gangadhara MS
SQL Developer and DBA

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-08 : 08:03:13

Tried changing protection level of package to "Rely on server storage..."?

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-09-12 : 01:56:23

Hi All,

As i am using the file server storage type for the SSIS package i am not able to store the password on Server.

Could you please assist if anybody faced this issue before.

Thanks,
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources