Symptoms

When you schedule a Microsoft SQL job to process the BIO cubes, you receive the following error message in the SQL Server Agent's job history event log:

Description: Failed to decrypt protected XML node


Resolution

To resolve this issue, follow these steps:

  1. Open SQL Server Business Intelligence Development Studio.

  2. On the File menu, click New Project, and then select Integration Services Project.

  3. Right-click SSIS Packages, and then select Add Existing Package.

  4. Select the Cube processing package to add in the SSIS Package window.

  5. In the upper-right corner of Visual Studio, double-click the package in Solution Explorer.

  6. Edit the BIO_SQL connection in the Connection Manager window and select the Windows Authentication option.

  7. On the File menu, click Save <PackageName> As on the SQL Server Business Intelligence Development Studio toolbar, and then save the package to your desktop.

  8. Log on to Microsoft SQL Server Management Studio, and then right-click the MSDB folder under the SSIS instance.

  9. Select Import Package, and then select the package that you saved to your desktop.

  10. When you are prompted, overwrite the existing package.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×