title: Using Temp tables in SSIS
body: <p>I am using a Temporary table in Stored Procedure in SQL Server.
  I am trying to use that SP in OLE DB Source Editor.</p>
  
  <p>I can see the data output returned in the Query Builder that comes with Build Query button.
  But when I Click the Columns tab, I am getting the below error.</p>
  
  <blockquote>
    <h2> - TITLE: Microsoft Visual Studio</h2>
    
    <p>Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code
    DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code:
    0x80004005. An OLE DB record is available.  Source: "Microsoft SQL
    Server Native Client 10.0"  Hresult: 0x80004005  Description: "Invalid
    object name '##Payment'.".</p>
    
    <p>Error at Data Flow Task [OLE DB Source [1]]: Unable to retrieve column
    information from the data source. Make sure your target table in the
    database is available.</p>
  </blockquote>
  
  <p>Does that mean I cant use temp tables in SP, if I want it to be consumed by SSIS</p>