Description

To create complex ETL solutions you can use control flow and data flow. Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations in the control flow. By using the control flow Data Flow Task, data flow can be implemented into the SSIS package to specify the source of the data, how the data should be transformed, and then the data destination. This course discusses and show how to design and implement the control flow elements. It also explains the different types of transformations to transform the data and how to implement them on the data that is extracted for the source. This course is one of a series in the Algeo 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.