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: 180

Filed under:
|
|

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

Related posts about ssis

Related posts about sql