organic coder (1/26/2012)
valuable discussion when viewed more from the conceptual rather than strictly implementation perspective. That aside, how reusable are components developed at the SSIS and SqlAgent level alone?
For SSIS, extremely re-usable if you know what you're doing. Not so much if you are new to SSIS.
We have an ssis framework in place at work that allows us to quickly ramp up new clients with HRIS integration, usually limiting our development time down to about 20 hours per client (for custom business logic, and custom validation).
I think the question that was posed is a valid question...it seems like an awful lot of work to put all of this together and basically rely heavily on stored procedures, and re-utilizing template stored procedures, when something like this can just as easily be handled with SSIS, SQL Agent, and checkpoints.