Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  WCF web service through SSIS

Author  Topic  hrishy Starting Member 47 Posts Posted - 2008-05-01 : 17:15:41 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 feilds 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. regards Hrishy