ssis reuse object variable ResultSet

Question

i use an Execute SQL Query Task to get a ResultSet into an object variable in SSIS. However if another task uses this ResultSet within a foreach loop and a 2nd task wants to use the same ResultSet afterwards it seems to be empty. I figured out that it seems to be empty because the pointer remains at the end of the Resultset after first use.

Is there any possibility to move the pointer to the beginning againt?

While your attempt to keep your code concise is admirable, why not just use a second object variable or repopulate the object instead? — Eric Hauenstein

bjnr bjnr · Accepted Answer · 2014-08-08T07:55:46

1

votes

Use Multicast task to copy the same data to multiple destinations.

ssis reuse object variable ResultSet

1 Answers