Post reply

Result Set from Stored Procedure to destination table

  • November 12, 2010 at 9:13 am

    #388215

    Hi,

    I have stored procedure which returns the result set and i want to store this result to a table how can i do this using SSIS.

    Please send me the links or example for the same.

    Thanks. 🙂

  • November 12, 2010 at 11:46 am

    #1250182

    Execute the stored procedure in an OLE DB Source in a dataflow. Connect the source to an OLE DB Destination to write the results to the preferred table.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 14, 2010 at 10:48 pm

    #1250542

    Thanks for Reply

    But When i click on Columns tab it is not showing the columns names.

    FYI my SP take nearly 3 min to execute it that any concern ?

    Thanks

  • November 15, 2010 at 12:24 am

    #1250552

    That is a concern.

    But, if your SP returns a result set, you should have columns.

    Try rewriting the SP with TOP 1 or something like that, so that it speeds up and so that you can see if you get columns or not.

    (and maybe consider rewriting the SP to a query that doesn't take 3 minutes, if possible)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply