Integration Services Fundamentals

via Pluralsight

Overview

Course Title: Integration Services Fundamentals

Description: Ready to learn SSIS? This course is tailored for business intelligence developers, database professionals, and individuals with no prior experience with Integration Services. Sign up now! This instructional program delves into developing Integration Services packages, emphasizing processes that support data warehousing.

The course begins by outlining the general package development process, followed by a detailed explanation of the various tasks within Integration Services. It demonstrates how these tasks can be executed sequentially or in parallel through control flow using precedence constraints.

Subsequently, the course reviews data flow components essential for the extract, transform, and load (ETL) processes. Additional topics include the Integration Services expression language, scripting, debugging packages, configuring logging, managing transactions, and handling package restarts. Moreover, the course illustrates how to automate the execution of packages.

Focusing on features and demonstrations in the SQL Server 2008 R2 release, most topics also extend to earlier versions of Integration Services.

University and Provider: Pluralsight

Categories: Data Warehousing Courses