What could be better you ask. How about doing it all in the database and leaving out he SSIS stuff. I had an occasion in the old 2000 days when I needed to move to a new server. The database was no problem but we had loads of DTS jobs to maintain the Disaster Recovery and Data Warehouse. That was a nightmare. Since then, I've tried to do everything with stored procedures and SQL Agent jobs which makes moving from one server to another a doddle.

Perhaps SSIS is easier to move than DTS? I have yet to get my fingers dirty with it. I'd be interested in your comments.