I tried creating a webservice task within SSIS, and I kept getting errors. The provider said all of my connections were setup correctly, so they did not know what was wrong. The problem turned out to be something very simple.
I setup a webservice task according to the providers specifications.
But when I try and run it, I get this lovely error:
[Web Service Task] Error: An error occurred with the following error message:
Could not execute the Web method. The error is: Could not load file or assembly
‘Microsoft.SqlServer.WebServiceTask, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91’
or one of its dependencies. The system cannot find the file specified..
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo,
String serviceName, Object connection, VariableDispenser taskVariableDispenser)
To fix this error, first go to solution explorer and right click on your solution and select properties.
Now under configuration properties, select general. On the right side it asks for your target server version. I am running Sql Server 2016, but it defaulted to Sql Server 2017.
I change it to match my environment, which is 2016 and click apply.
It asks me if I am sure, and click yes.
Then it prompts you to save your solution files, I said yes to all.
I try running the webservice again, and now it works!
Always make sure that the settings that get published are appropriate for your environment.