Upgrading to SSIS 2012 and SSIS 2014, The Microsoft Business Intelligence (BI) toolset is constantly evolving with every new release of SQL Server. One tool used for Extracting, Transforming, and Loading (ETL) data from data source(s) to destination(s) is SQL Server Integration Services (SSIS). Besides being an efficient, enterprise-scale ETL utility, it is freely bundled with Microsoft SQL Server (no extra licensing!).
SSIS was pretty consistent for SQL Server 2005, 2008, and 2008 R2. However, with the release of SQL Server 2012, the designer and deployment model were upgraded along with much needed features. This Oxygen Blast will cover many of the changes that occurred with SSIS with the release of Microsoft SQL Server 2012. No changes were made with SSIS 2014 which allows you time to learn the new features of SSIS and upgrade your packages.
This presentation will cover how Business Intelligence Development Studio (BIDS) has become SQL Server Data Tools for Business Intelligence (SSDT-BI). It will walk through the upgraded designer with new features such as the new Parameters tab, new Control Flow and Data Flow capabilities, and some of the much needed bug fixes (finally!). We will also cover the new SSIS deployment model. Finally, we will also cover the features which are no longer supported by the newest versions of SSIS, such as support for DTS 2000 packages. Join us to help you prepare for your SSIS upgrade!
Davin Mickelson Instructor @Intertech
With a decade of experience as a consultant in software architecture/development and project management, Davin Mickelson primarily focuses on understanding the "hows" and "whys" of the latest Microsoft solutions. He is also a passionate computer instructor who cares about his students. Their understanding of the technologies is more important than how fast the class can get through the book in a week of training. He loves working with Microsoft technologies and is eager to help others. He specializes in Microsoft development and database technologies, including Visual Studio with .NET (C# and VB), ASP.NET, MVC, ADO.NET, XNA, LINQ, AJAX, SQL Server 2005/2008 SSAS/SSIS/SSRS, and Team Foundation Server 2005/2008/2010.
1:00 PM - 2:00 PM
Meeting Type: Webinar
Webinar access information will be emailed to event registrants prior to the time of the event.