Description

SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. SSIS is extensible because developers have the ability to create custom components if the integrated components do not suit their needs. In this course we cover how to develop and install custom components and implement script tasks. Also discussed are the different types of Slowly Changing Dimensions (SCD), and how to manage data that slowly changes over time. 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.