| Maintaining and Transforming Data with Ssis |
ID: SQSSIS | Course Length:3 | Company Name:Choquette Technology Associates Inc.
|
|
Module 0: 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
|
|
Module 1: 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
|
|
Module 2: 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
|
|
Module 3: 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
|
|
Module 4: 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
|
|
Module 5: 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
|