Table Variables in SSIS
Posted
by aceinthehole
on Stack Overflow
See other posts from Stack Overflow
or by aceinthehole
Published on 2010-05-04T18:24:55Z
Indexed on
2010/05/04
18:28 UTC
Read the original article
Hit count: 197
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 temp table if it is not possible to use table variable. Also I cannot use the record set destination as I need to preform straight SQL tasks on it later on.
© Stack Overflow or respective owner