title: SSIS OLE DB Source using providers
body: <p>I'm using a procedure that uses a table variable to fetch relevant data from my DB, and then returns whatever is stored in that table variable to my data flow.</p>
  
  <p>My OLE DB Source is only designed to run the SQL command EXEC FetchData_prc.</p>
  
  <p>It shows the required columns in the Source Editor, and it also lets me do mapping, preview and all of that.</p>
  
  <p>YET, when running the package, it throws the error: <code>[OLE DB Source [1]] Error: A rowset based on the SQL command was not returned by the OLE DB provider.</code></p>