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.