SQL Server Performance

How to make ##temp table available and to be used by multiple data flow processes within a data flow task

Discussion in 'SQL Server 2005 Integration Services' started by WingSzeto, Aug 22, 2008.

  1. WingSzeto Member

    In my data flow task, I have three 3 sets of data flow and each is using the same OLE db source but each has its own output text file. Each of the data source has multliple table joins and majority of the joins are the same. So instead of running that joins three times, I can run a query to put the join result to a ##temp table to simplifize it. My question is how do I make ##temp available for these 3 set of data flow to use.
    Any help is very much appreciated.
    wingman
  2. moh_hassan20 New Member

    ##temp is a global temporary table and can be shared with different sessions.
    let first data flow procedure create ##temp table
    process ##temp as normal
    third data flow procedure drop it
    or
    Manage crate /drop it as needed bet. sessions.
    why not use perminant table, with index and fill /truncate it as needed.[;)]

Share This Page