Executing Web Service in a ForEach Loop with Result Set

Question

Executing Web Service in a ForEach Loop with Result Set

kishoregowtam

SSC Enthusiast

Points: 114
More actions
April 20, 2009 at 12:38 am

#130713

Hi All,
1. I m having webservice to insert Employees. Method name InsertEmp which requires Employee object as input.
2. Input for web service comes from another database lets say DB1.
3. I need to loop through each row of result set and set that as input parameter for web service task for insertion.
Please let me know how to set result set of sql task as input for web service task in a fmor each loop.
Thanks,
Gowtham

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

vishal.gamji SSCertifiable Points: 6126 More actions · Answer 1

Set the ResultSet of the Execute SQL Task to full result set, then in the resultset tab, add a result set with Name = 0 and map it to a variable (create a variable of type 'Object').

When accessing the for each loop, use the ADO enumerator and the items will be enumerated in ordinal position.

kishoregowtam SSC Enthusiast Points: 114 More actions · Answer 2

Hi,

Thnks for the reply.

But My issue is suppose webservice is having a method Insert(Employee emp). It requires input parameter of type Employee.

How can we dynamically assign SQL Task results to the webservice input parameter.

Thanks,

Gowtham

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 3

kishore

Were you able to find a solution for your problem. i have same scenario not able to do the parameter to web service task.

Please let me know if you have a solution which will help me

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 4

you can do webservice task and parameter by installing sp3 (sql server 2005)