A better SSIS? Migrating a datawarehouse to SQL Server 2012
The new and improved SSIS promises not only rounded edges and new icons ;-)
It has a whole lot of features to help control larger projects.It comes with a migration wizard to allow you to get up and running pretty quickly with all the new features.
But what if you have a large project and have already built a lot of DIY project management.
(error handling, running multiple packages consecutive and / or parallel etc.)I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) to see what the benefits are and how easy it will be.
This session will be a walkthrough of this process and a lessons learned.
André is a freelance SQL Server specialist. He has done a lot of DBA work on 100’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW.
André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland