SSIS Package Error "A rowset based on the SQL command was not returned by the OLE DB provider.” while using Stored Procedure as Source. Scenario: Lately I’ve come up with a unique requirement in which data movement is required from SQL Server source and multiple nested conditions left me with no other condition but to use Stored Procedure as source….