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.
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.
User contributions licensed under CC BY-SA 3.0