SSIS and WCF webservice

Question

Hi

I need to populate a table B by selecting a from table A but for every single record selected from Table A for some of the fields I need to pass it to a WCF webservice and do some tasks.

Can somebody show me an example on how to invoke a WCF webservice for every single row fetched from a database through a script component

A step by step example would be of great help.

Answer 1

SSIS allows you to call a web service, you can use this to call a WCF service with basic http binding

The blog post in the folling link contains a link to a video on how to do ths.

http://consultingblogs.emc.com/jamiethomson/archive/2007/06/19/SSIS%5F3A00%5F--Consuming-web-services-in-SSIS-2008.aspx