Power Query Connector - SSIS 2019 - Failing Package When Deployed

Fagg, Daniel 6 Reputation points
2021-02-11T13:27:14.93+00:00

I have created a simple package that uses a Power Query connector and loads into a sql server table. I have developed this in Visual Studio 2019 and installed the required Power Query Connector (I am developing in VS on the server I am also deploying to).

I can execute the package in Visual Studio successfully, however when I deploy it to SSIS server and execute from a job step I get an error on the package:

Package:Error: The data protection operation was unsuccessful. This may have been caused by not having the user profile loaded for the current thread's user context, which may be the case when the thread is impersonating.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,158 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Miguel Escobar 326 Reputation points
    2021-02-28T18:41:17.997+00:00

    Hi!
    This error often appears related to the package itself and not the Power Query component.

    Are you able to run other packages within that server without any issues?
    I just did a quick search online and found that same error on a thread in stackoverflow which might help you.

    0 comments No comments