CODEWITHSUNDEEP
ssisexport-to-excel
Vivek
Vivek

Reputation: 255

SSIS OLE DB Source using providers

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.

My OLE DB Source is only designed to run the SQL command EXEC FetchData_prc.

It shows the required columns in the Source Editor, and it also lets me do mapping, preview and all of that.

YET, when running the package, it throws the error: [OLE DB Source [1]] Error: A rowset based on the SQL command was not returned by the OLE DB provider.

Upvotes: 1

Views: 1920

Answers (1)

Hazem Salama
Hazem Salama

Reputation: 15101

You may try to set nocount on on your stored procedure to prevent the server from returning the row count. This could be mistaken by SSIS as the returned result set. See this

Upvotes: 2

Related Questions