SSIS OLE DB Source using providers

Question

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.

Can you add any code from the proc? I'm interested to see if it returns using a select or if you return the table variable. — Vinnie
– Vinnie, Commented Oct 25, 2012 at 12:50

Hazem Salama · Accepted Answer · 2012-10-25 12:48:59Z

2

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

answered Oct 25, 2012 at 12:48

Hazem Salama

15.2k5 gold badges29 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS OLE DB Source using providers

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related