January 31, 2010 at 9:20 pm
hi guys i have a question regarding a ssis package i am trying to create.
I have a stored procedure which returns multiple result sets, can someone please tell me how to execute this stored procedure and insert the multiple result sets into a table in my sql server Database. I tried creating a data flow task inside i put a OLE DB source that executes my sp by exec sp_AllJobs then a OLE DB destination which is my sql server table and it executes ok but when i check i only have the first result set into the sql table 🙁
January 31, 2010 at 10:16 pm
Try a Copy Column task, or T-SQL Select into statement.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 1, 2010 at 12:23 am
There is no way to do this AFAIK. Either create multiple stored procedures that return one result set each and continu with the Data Flow Task or insert the data direclty from within the Stored Procedure (insetad of returning it as a result set) and use an Execute SQL Task.
February 1, 2010 at 12:41 am
thank you guys, yes i think you are right i have tried everything and still i always get the first result, i was thinking maybe by doing a for loop container or something similar there was a way... :crying:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply