Microsoft SQL Server 2012 – Implementing a Data Warehouse: Create Basic Packages

This course is included in our On-demand training solution.


ETL, extract, transform, and load, is the main process in data warehousing solutions. It facilitates the transfer of the data from a source to a destination, which may also evolve transforming the data during the process. This course discusses the ETL process and how it can be implemented and demonstrates how to create simple SSIS packages that use the Data Flow Task in SQL Server Data tools, SSDT. During the demonstration, how to use connection managers to specify the source and destinations for the data is also covered, as well as how to use other tasks to transform the data before it is extracted. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-463:Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.

Target Audience

Data Warehouse Developers and Database Administrators who create and manage business intelligence solution as part of their daily tasks, which include implementing data warehouse databases, extracting transforming, and extracting data as part of an ETL solution, and data cleansing.



Expected Duration

90 min.

Course Objectives

Creating Simple SSIS Packages in SQL Server 2012

  • describe the process for creating simple SSIS packages in SQL Server 2012
  • Using SQL Server 2012 SSIS Packages

  • describe the main elements of packages: connection managers, control flow, and date flow
  • Creating Connection Managers in SQL Server 2012

  • create and manage connection managers in SSDT
  • Using Data Flow to Load Data in SQL Server 2012

  • recognize how to create a basic package using data flow to extract, transform, and load data in SQL Server 2012
  • Use Data Flow to Load Data in SQL Server 2012