title: Invalid object name '#Results' SSIS when using sp in dataflow
body: <p>I have a stored procedure that runs fine in SQL Management Studio but I'm having problems running it in SSIS 2008 R2. If I run it as an <code>Execute SQL Task</code>, it runs fine without any errors but when I use it as an ADO NET Source in a Data Flow Task, I get an error messaging </p>
  
  <blockquote>
    <p>Invalid object name #Results (Microsoft SQL Server, Error:208)</p>
  </blockquote>
  
  <p>However when I click Preview, I do get rows of data displayed. </p>
  
  <p>I don't have access rights to modify the stored procedure so I'm not sure what is going on inside the stored procedure itself but as I have said previously, I can run the stored procedure in management studio and when used in an Execute SQL Task in SSIS. </p>