Home > SSIS, Technical > How to call wcf service from ssis 2005

How to call wcf service from ssis 2005

The following link explains how to call wcf service using a web service task.

http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html

A point to note is that the scripting in ssis 2005 has .Net 2.0 framework. XmlSerializer is quite an old technology which is used in web services. Windows Communication Foundation supports it for backwards compatibility.
The DataContractSerializer does not support the programming model used by the XmlSerializer and ASP.NET Web services. In particular, it does not support attributes like XmlElementAttribute and XmlAttributeAttribute. To enable support for this programming model, WCF must be switched to use the XmlSerializer instead of the DataContractSerializer.

http://msdn.microsoft.com/en-us/library/ms731923.aspx

Calling a WCF Service from SSIS produces issue with setting variable values

http://www.bloggingbunk.com/2011/09/solving-the-parameter-value-missing-mystery/

Sometimes there may be

connection problems

You have to overcome this from client code (from the service which calls other service). Use this code in the initialization of your service application to increase connections:

System.Net.ServicePointManager.DefaultConnectionLimit = 10;

http://stackoverflow.com/questions/3814993/multiple-concurrent-wcf-calls-from-single-client-to-service

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: