none
Integration Services Connector for Power Query error RRS feed

  • 問題

  • I install SQL Server Connector for Power Query for SQL server 2017 (on both test and prod servers). Create in SSDT SSIS package with power query connector. It works perfect in SSDT! But when I deploy progect to SSIS catalog, I get error:

    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.

    Moreover, when I import this package from ssis catalog to new project, power query connection manager go away from project with error:

    The connection "{EFC6889A-D312-4A9E-B251-877C7A67B8DF}" is not found.
    his error is thrown by Connections collection when the specific connection element is not found.
    2022年4月18日 下午 07:55

所有回覆

  • How do I grant access to Integration Services?
    2022年6月13日 上午 04:04
  • Hi James,

    This is the only article I have found useful to grant access to Integration Services. Using this you can provide least privilege access  to users.

    https://docs.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver16


    2022年6月13日 下午 03:32