Microsoft SQL Server Integration Services
This two-day training is designed to help understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. Through a variety of lab exercises and real-world examples, students will gain familiarity in how the design and execution environments work.
Audience
The target audiences of this class are developers, architects or IT professionals who have basic SQL skills.
Prerequisites
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- At least 2 years’ experience of working with relational databases
- A solid understanding of SQL objects, to include tables, relationships, columns, data types, etc.
- Some exposure to basic programming constructs (such as looping and branching).
Module 1: Creating an ETL Solution
At the end of this module you will be able to implement data flow in a SSIS package.
Lessons:
- Introduction to ETL with SSIS
- Exploring Source Data
- Implementing Data Flow
Lab: Implementing Data Flow in an SSIS Package
After completing this module, you will be able to:
- Describe ETL with SSIS
- Explore Source Data
- Implement a Data Flow
Module 2: Implementing Control Flow in an SSIS Package
This module describes implementing control flow in an SSIS package.
Lessons:
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints
After completing this module, you will be able to:
- Describe control flow
- Create dynamic packages
- Use containers
Module 3: Debugging and Troubleshooting SSIS Packages
This module describes how to debug and troubleshoot SSIS packages.
Lessons:
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
Lab: Debugging and Troubleshooting an SSIS Package
After completing this module, you will be able to:
- Debug an SSIS package
- Log SSIS package events
- Handle errors in an SSIS package
Module 4: Extending SQL Server Integration Services (SSIS)
This module describes how to extend SSIS with custom scripts and components.
Lessons:
- Using Custom Components in SSIS
- Using Scripting in SSIS
Lab: Using Scripts and Custom Components
After completing this module, you will be able to:
- Use custom components in SSIS
- Use scripting in SSIS
Module 5: Deploying and Configuring SSIS Packages
This module describes how to deploy and configure SSIS packages.
Lessons:
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
Lab: Deploying and Configuring SSIS Packages
After completing this module, you will be able to:
- Describe an SSIS deployment
- Deploy an SSIS package
- Plan SSIS package execution
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date