Post reply

Executing stored procedure using SSIS

  • January 21, 2009 at 2:03 am

    #127474

    Hi Friends,

    I have a stored procedure which populates a table.

    What I have to do exactly is I have to execute the stored procedure, and then use that table. From that table, I have to export data to other table in other database.

    I have to do this in SSIS.

    Can u plz suggest me how to do this using SSIS and execute stored procedure using SSIS.

    Thanks.

  • January 21, 2009 at 2:37 am

    #930178

    You can execute T-SQL statements in "Execute SQL Task"

    --Ramesh

  • January 21, 2009 at 4:35 pm

    #930783

    You can do this with an Execute SQL task and a Data Flow task. You will also need two connection managers, one for the database your stroed proc is in and one for the database you want to push data to.

    Use the Execute SQL task to call the stored proc. Then follow that with a Data Flow task. Inside the data flow task you can use an OLE DB source and a destination. In the source set the connection manager to the database where your stored proc created the data and select the appropriate table. Connect the output path to the destination. Open the destination, set the connection manager, select the table and check the mappings.

    That should get you started.

  • January 21, 2009 at 7:39 pm

    #930844

    Thank you friend.

    Got it worked.

    thanks.

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

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