Home Forums SQL Server 2005 SQL Server 2005 Integration Services create a SSIS package which will call the stored procedure and dump the output of the procedure into table RE: create a SSIS package which will call the stored procedure and dump the output of the procedure into table

  • January 19, 2011 at 3:23 am

    #1275166

    Karan_W (1/19/2011)

    I want to create a SSIS package which will call the stored procedure and dump the output of the procedure into table.

    This stored procedure accept an input parameter e.g. Date which i can retrieve from another table like select max(Date) from userid and pass to procedure.

    SSIS packae will return the output and i need this resultset ouput to dump into another table.

    But before inserting i want to delete the rows from that tables if any rows exist for that date and then finally insert the resultset.

    ..and your question is?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.