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.
(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
I'm a Dutch SQL Server consultant. Having worked as a DBA on 400+ instances for the past couple of years.
I'm on a datawarehouse project right now where I find myself using SSIS mostly these days.
I run the Dutch PASS chapter, and I'm a SQL Server MVP
- Video
The video is not available to view online.
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.