November 30, 2011 at 11:24 pm
The requirement is to get the data from source using simple select query. I am using execute sql task for this and assingning resultset of execute sql task to Full result set and also using one object type variable.
Now i need to loop through this object varaible and pass 4 variable to stored proc for each row.
How i can achive this..i want to use For each ADO numerator. Please help me with the steps.
November 30, 2011 at 11:35 pm
I would do this in a data flow instead of using control flow.
data source -> oledb command transform
Should take around 5 minutes to put together.
December 1, 2011 at 12:46 am
That is great. It worked.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply