title: Use temporal table on SSIS using OLE DB source editor
body: <p>I want to execute SP who have temporal table and querys with 600 lines of code. So I insert SP code into variable and then I call OLEDB Source editor </p>
  
  <p>temp table:</p>
  
  <pre><code>IF OBJECT_ID('tempdb..##TGJAE' ) IS NOT NULL DROP TABLE ##TGJAE 
  
  SELECT
     VOUCHER,
     DATAAREAID,
     TAXITEMGROUP,
     TAXBASEAMOUNT,
     SOURCERECID
  INTO ##TGJAE
  FROM TAXTRANS 
  </code></pre>
  
  <p>but when I try to save I get issue:</p>
  
  <blockquote>
    <h2>TITLE: Microsoft Visual Studio</h2>
    
    <p>Exception from HRESULT: 0xC020204A Error at Flow [Query
    [16]]: 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 11.0"  Hresult: 0x80004005
    Description: "The metadata could not be determined because statement
    'SELECT  VT.ACCOUNTNUM as [Código de Proveedor], "RFC" = CASE when
    V.RFC_MX = '' then v.VATNUM else v' uses a temp table.".</p>
    
    <p>Error at Flow [Query [16]]: Unable to retrieve column
    information from the data source. Make sure your target table in the
    database is available.</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/auT3P.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/auT3P.png" alt="enter image description here"></a></p>
  
  <p>Any one know what happen there? Regards</p>