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;