Error: A rowset based on the SQL command was not returned by the OLE DB provider. Cause: Usually it happened when the usp using multiple query calls in the procedure Resolution: Write the below given code at the top of sp in OLEDB source component of SSIS and the code would be something like given below: SET NOCOUNT ON SET ANSI_WARNINGS OFF EXEC <usp_Name>