Maintaining and Transforming Data with SSIS
(SSISCOMP, 3 days)


Description

This SETC certified course covers the full range of SSIS concepts from the basics of data sources to advanced data flows and control flows. The course begins with a tour of the BIDS (Business Intelligence Development Studio) environment and its many windows, dialog boxes and features, From there, the student is taken through a comprehensive investigation of basic tasks such as importing data from delimited and positional files, exporting data to external data sources and implementing simple error conditions. Having mastered the basics, the course proceeds to study the intricacies of complex data transformation tasks which require transformations, NULL value handling and encoding changes. This comprehensive learning event concludes with a case study which shows participants how to load a data warehouse using SSIS packages. If you want to use SSIS to manipulate your data, this SETC certified course is the course for you.

Dates and Pricing


Jan 17 to Jan 19, 2018$2,250/person Feb 14 to Feb 16, 2018$2,250/person Mar 14 to Mar 16, 2018$2,250/person

Outline

SSIS Overview
SQL Server Core Services
SSIS Architecture
The .NET Framework Runtime
About .NET Namespaces
Using BI Development Studio
Creating a SSIS Project
Debugging a SSIS Package
SSIS Essentials
About the Integration Services Template
Understanding Data Sources and Data Source Views
About Packages and the Package Explorer
Creating Packages
About Control Flow and Data Flow
About Event Handlers
SSIS Data Sources
The Need for a Data Connection
Establishing a Connection using a Provider
About SQL Server and Oracle Connections
Creating a Data Source
Using Data Source Views
SSIS Control Flow
Creating a Package
About Package Templates
The Need for Data to Process Separation
Distinguishing between the Control Flow and the Data Flow
About the Control Flow Designer
Implementing Structure with Containers
Implementing Functionality with Tasks
Implementing Precedence with Precedence Constraints
SSIS Data Flow
Understanding the Need for Data Flows
About the Data Flow Designer
Implementing Inputs with Data Sources
Implementing Outputs with Data Destinations
Modifying and Aggregating Data with Tranformations
Connecting Inputs and Outputs with Data Paths
Handling Errors
Implementing Event Handlers
Common Tasks
Using SSIS to Import and Transform Data
Using SSIS to Export and Transform Data
Using SSIS to Transfer Data between Servers
Using SSIS to Load a Data Warehouse
Using SSIS to implement a Complex Business Process
Loading a Data Warehouse with SSIS