title: SSIS ole db source using stored procedure cannot retrieve meta-data for columns
body: <p>I'm using a stored procedure for ole db source in SSIS. It always pops out error when I click on "Columns" panel.  However, the same query executes successfully in SSMS and in "Build Query..." window. 
  <img src="https://i.stack.imgur.com/UMbor.png" alt="enter image description here"></p>
  
  <p>In the stored proc., no temp table but table variable is used. I did a lot research online but all similar cases seem to be caused by temp tables.</p>