I haven't used it extensively, but SQL Server Integration Services (SSIS) looks like it does a lot of the things you're talking about.