one of my colleague asked me about whether is it possible to create and use
Local Temporary tables in SSIS. I did a little bit of googling and finally
gathered some good information. I thought to share the information, although I
found many posts on this topic.
tables are created in the TempDB database, which persists for a particular
session. The objective is to maintain that session, until the temp table
information is used and dump the data into a physical table. To maintain a
session in SSIS, there is a ‘Retain Same Connection’ property of the Connection
Manager. If we need to maintain a single session, we have to mark this property
‘True’.Please visit this article on sql-server-performance to read the complete steps.
Tags: Temporary table, SSIS, RetainSameConnection
Nice Tip. Go to Connection Manager--->Right Click--->Properties--->RetainSameConnection= TRUE.
Thanks Bala. I hope you have visited the complete article link on sql server performance http://www.sql-server-performance.com/2013/temp-tables-ssis/
Yes , i have visited that link
This comment is waiting for moderation.