I'll try to explain my problem as clearly as I can:
1)I have an Execute SQL Task that's inside a Foreach Loop Container.
2)Inside the Execute SQL Task, I have an int OUTPUT column.
3)With each iteration, I need to insert the data from the INT output colum into a table variable.
4)After the Foreach Loop finishes the iterations, I need to use the table variable to create a report based on the data inside.
My question is the following:
How can I declare a table variable so that I can do all of the above?
View Complete Post