title: SSIS no column information was returned by the sql command
body: <ol>
  <li><p>I ran my Stored Procedure in <code>BI_Test_Server</code>. </p></li>
  <li><p>Then I executed it using <code>exec [dbo].[bi_resource_dimension_sp] 1,1</code></p></li>
  <li><p>I got the results in <code>SQL Server management Studio</code> successfully. So I created a <code>Data Flow task</code>, put the OLE DB source, Data Connection and OLE DB destination. I edited OLE DB source and created a new connection. Inside OLE DB source SQL Command : SQL Command Text I put the Step 4.</p></li>
  <li><p>In the OLE DB Source – SQL Command Text, I put the <code>exec [dbo].[bi_resource_dimension_sp] 1,1</code> in order to select all the data from the OLE DB source then connect it to the Data Connection and dump the data in the OLE DB Destination.</p></li>
  <li><p>But when I try to preview the results, I get the error that <strong>no column information was returned by the SQL command</strong>.</p></li>
  </ol>
  
  <p>Ideally, I need to tick all of the check boxes to make sure in which column to get and put the data. Which is what I'm trying and about to do after Step 4.</p>
  
  <p>It says on the error that you may <em>“Choose Ok if you want to continue with the operation”</em>. But if I do that, when I go the columns section (on the top left portion between connection manager and error output). It’ll show me blank columns.</p>
  
  <p>Please help.</p>