Archive

Posts Tagged ‘web service’

How to call wcf service from ssis 2005

October 12, 2011 Leave a comment

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