title: How to create a temporary table in SSIS control flow task and then use it in data flow task?
body: <p>I have a control flow where I create a temp database and table in a with a T-SQL Command. When I add a dataflow I would like to query the table but I can't because the table doesn't exist to grab information from. When I try I get errors about logging in because the database doesn't exist (yet). I have delay validation to true. </p>
  
  <p>If I create the database and table manually then add the dataflow with query and drop the database it sticks but it doesn't seem like a clean solution. </p>
  
  <p>If there is a better way to create a temporary staging database and query it in dataflows please let me know.</p>