Font size:

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 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 how to use scripting components in SQL Server 2012 SSIS
  • identify the planning considerations for custom components in SQL Server 2012 SSIS
  • describe how to manage data that slowly changes over time
  • implement the custom components and handle slowly changing dimensions in SQL Server 2012 SSIS
Register Now
Microsoft SQL Server 2012 – Implementing a Data Warehouse: Custom Components Online course
  • Course ID:
    242247
  • Duration:
    90 minutes
  • Price:
    $75