SSIS: Error running Webservice

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.

ws1

But when I try and run it, I get this lovely error:

ws2

[Web Service Task] Error: An error occurred with the following error message:
“Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException:
Could not execute the Web method. The error is: Could not load file or assembly
‘Microsoft.SqlServer.WebServiceTask, Version=14.100.0.0, 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)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()”.

 

ws3

 

To fix this error, first go to solution explorer and right click on your solution and select properties.

ws4a

 

ws4

 

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.

ws5

 

I change it to match my environment, which is 2016 and click apply.

ws6

It asks me if I am sure, and click yes.

ws7

 

Then it prompts you to save your solution files, I said yes to all.

ws8

 

I try running the webservice again, and now it works!

ws9

ws10

Always make sure that the settings that get published are appropriate for your environment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s