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 

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