Tutorial :SSIS and WCF webservice


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.


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.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »