Table Variables in SSIS
- by aceinthehole
In one SQL Task can I create a table variable
DELCARE @TableVar TABLE (...)
Then in another SQL Task or DataSource destination and select or insert into the table variable?
The other option I have considered is using a Temp Table.
CREATE TABLE #TempTable (...)
I would prefer to use Table Variable so that it remains in memory. But can use…