BI, Big Data, Data Analytics, and Data Visualization

SQT09 Using Integration Services 2014 (SSIS) to Load a Data Warehouse


2:00pm - 3:15pm

Level: Introductory to Intermediate

Thomas LeBlanc

Data Warehouse Independent Consultant

Data on the Geaux

Need to ramp up your SQL Server Integration Service (SSIS) skills for a Data Warehouse implementation? Get everything you need to learn in this session for loading data from various sources into Dimensional Model data marts using SSIS 2014.

This session will walk you through the process of importing data from various data sources with new features like the Change Data Capture component for incremental loads. Data Quality Service can cleanse data before importing. Package Logging and Reporting has been enhanced with Projects and their deployment to a single container. During package development, the new organization of the environment will feature improved usability with copy and paste of components, display and execution flow. The Project parameters and connections help with configuration execution for development testing and production. You'll leave the session with resources for everything covered, plus the project packages used throughout the demonstration.

You will learn:

  • Understand the new features in SSIS 2012/2014 that make this product and Enterprise Level ETL/ELT tool
  • Develop ETL at the project level rather than a package level
  • Optimize SSIS to import data from various data sources and succeed in loading quality data into a dimensional model