title: Use temp tables in SSIS packages
body: <p>I am writing a basic file dump from one database to another. I am using SSIS 2008 and creating several packages to transform the data I have from a MSSQL 2010 database to a MYSQL 5.1 database. </p>
  
  <p>All the connections are set up and records can be tranfered between the two databases but I would like to use temp tables in the transform processes and use the temp table as the MSSQL source in a dataflow task to dump the table in an awaiting MYSQL table.</p>
  
  <p>I have been having problems setting this up. I am using an OLEDB connection and have set the RetainSameConnection property as well as the DelayValidation property to true. When setting up the source figure as the source from the MSSQL database I cannot find the temp table I have created in an earlier task from the control flow. I am using the same connection manager for these two tasks.</p>
  
  <p>Anyone have any ideas or experience with this?</p>
  
  <p>As a simple example one task does..</p>
  
  <pre><code>SELECT * 
  INTO #TMP
  FROM CUSTOMERS
  </code></pre>
  
  <p>(This is a simplified example and I relize in this case I could just use the Customers table so bear with me)
  Is it possible to use this temp table in a dataflow operation as the source table?</p>