I am just wondering if this is a feasible option within SSIS.
I have a source database on one server, a destination database on another server
The source database has a stored procedure which returns lets say 500 records. 300 are inserts the rest updates. (Based on some column)
So in SSIS I call this SP, following this im able to loop through the records returned figure out wether its Insert or Update and then move the data to destination table.
View Complete Post