Error connecting cloud database executing OLAP JOB

0

I've created some OLAP Cubes and a DTSX Package. In this package I connect into a cloud database to get my data and put in on local sql analysis service. On Visual studia when I execute it it works fine but when I try to run it on local Sql in SQL Server Management Studio with a JOB it gives me errors on cloud database credentials.

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.

Tried to change Protection level and to wait for validation.

ssms
olap-cube
asked on Stack Overflow Feb 25, 2021 by Tweene • edited Mar 2, 2021 by Tweene

1 Answer

0

Solved by adding manually password in the dtsx package into the connection string for cloud. THe package it self didn't saved the sensitive data provided in the connection manager.

answered on Stack Overflow Mar 10, 2021 by Tweene

User contributions licensed under CC BY-SA 3.0