CODEWITHSUNDEEP
sqlsql-serverssis
tuxmania
tuxmania

Reputation: 956

ssis reuse object variable ResultSet

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?

Upvotes: 2

Views: 859

Answers (1)

bjnr
bjnr

Reputation: 3437

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

Upvotes: 1

Related Questions