Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

I have around 6+ years of experience in SQL Server development and in Business Intelligence area. I am working as Datawarehouse developer. My blog space includes all technical areas related to SQL Server and MSBI (SSIS, SSRS and SSAS).
Browse by Tags · View All
SSIS 7
xml 3
dynamic 3
Union All 3
SSRS 2
Data flow task 2
Buffer 2
Time 2
Date 2
varchar(max) 1

Archive · View All
February 2013 3
September 2009 3
June 2013 2
January 2013 2
November 2012 2
July 2012 2
July 2009 2
April 2013 1
December 2012 1
February 2010 1

Using Temporary tables in SSIS

Feb 12 2013 12:00AM by Divya Agrawal Shah   

Recently 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.

Temporary 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


Divya Agrawal Shah
89 · 2% · 629
3
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

4  Comments  

  • HI Divya,

    Nice Tip. Go to Connection Manager--->Right Click--->Properties--->RetainSameConnection= TRUE.

    Thanks.

    commented on Feb 13 2013 7:53AM
    Bala Krishna
    84 · 2% · 676
  • 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/

    commented on Feb 14 2013 11:34PM
    Divya Agrawal Shah
    89 · 2% · 629
  • Yes , i have visited that link

    Thanks.

    commented on Feb 15 2013 3:13AM
    Bala Krishna
    84 · 2% · 676
  • This comment is waiting for moderation.

    commented on Nov 27 2014 1:31AM
    Saravana
    3160 · 0% · 2

Your Comment


Sign Up or Login to post a comment.

"Using Temporary tables in SSIS" rated 5 out of 5 by 3 readers
Using Temporary tables in SSIS , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]