I have a ssis package. It has 3 tasks, first task updates a record in Oracle database to set an Indicator to “Y”, second task process SSAS Cube and the
third again updates the same record and sets the indicator to “N”. This package has 2 data sources, one is Oracle and the other is Analysis Services. I gave the credentials for the Oracle and use NT Authority for Analysis services.
When I am executing from BIDS package is executing successfully. But when I am calling the job to execute this package its throwing me the error. Below is the error.
Executed as user: User\Username. ...ion 9.00.4035.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:57:46 AM
Error: 2010-08-27 10:57:46.79 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: 2010-08-27 10:57:47.16
Code: 0xC0202009 Source: Ord_test Connection manager &q
View Complete Post