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.
- Describe the process for creating simple SSIS packages in SQL Server 2012
- Describe the main elements of packages: connection managers, control flow, and date flow
- Create and manage connection managers in SSDT
- Recognize how to create a basic package using data flow to extract, transform, and load data in SQL Server 2012
- Create a basic package using data flow to extract, transform, and load data in SQL Server 2012
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.