I am trying to use a stored procedure in the OLE DB source, I am using the SQL Command for the Data Access mode. It returns values when using the preview but when I test the SSIS package I receive the error, "A rowset based on the SQL command was not returned by the OLE DB provider
Solution
I just had to add SET NOCOUNT ON in the begining of the stored procedure that I was using.
