1
Vote

Deploy of this SSIS on SQL server 2012 fails?

description

This SSIS plug in is very useful to refresh power queries, but when i try to deploy as SSIS job it fails with below error

Package:Error: Cannot create a task from XML for task "Refresh Microsoft Excel Task", type "oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version=1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b" due to error 0x80070057 "The parameter is incorrect.".



Thanks in advance for any help

comments

clodola wrote Jul 11, 2016 at 2:33 PM

I have the same issue, anybody know how to fix?

nyiko4me wrote Jul 19, 2016 at 11:30 AM

Hi
I Had the same error and resolved it this way
Step 1
1) Start > Run > dcomcnfg
2) Navigate to Component Services > Computers > My Computer
3) Go to properties then select Com Security tab,
4) click on the edit button and give the user your SQL Agent is running on Access and Launch Permissions.
Step 2
Component services > Computers > My Computer > DCOM Config >Microsoft Excel application > properties > Identity Tab > Select the Interactive User > Ok.

clodola wrote Jul 19, 2016 at 2:01 PM

Thank you !