Overview
3 Days $2,430 or FREE WITH SATVs (?)
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
- Overview of SQL Server Integration Services
- Using Integration Services Tools
- (Level 200) Using the Import and Export Wizard
- (Level 200) Running an Integration Services Package
After completing this module, students will be able to:
- Describe Integration Services solutions
- Use Integration Services tools
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
- (Level 200) Creating an Integration Services Project
- (Level 200) Implementing a Package
- (Level 200) Building and Running an Integration Services package
After completing this module, students will be able to:
- Create a SQL Server Integration Services solution.
- Use variables.
- Build and run a solution.
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
- (Level 200) Creating a Simple Control Flow
- (Level 200) Configuring Precedence Constraints
- (Level 200) Using Containers
After completing this module, students will be able to:
- Configure control flow tasks.
- Configure control flow precedence constraints.
- Configure control flow containers.
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
- (Level 200) Transferring Data
- (Level 200) Implementing Transformations
- (Level 200) Using Data Viewers
- (Level 200) Configuring Error Output
After completing this module, students will be able to:
- Implement data flow sources and destinations.
- Implement basic data flow transformations.
- Implement advanced data flow transformations.
- Implement data flow paths.
- Overview of Integration Services Logging
- Enabling and Configuring Logging
- (Level 200) Configuring Logging
- (Level 200) Implementing Custom Logging
After completing this module, students will be able to:
- Describe Integration Services logging.
- Implement Integration Services logging.
- Debugging a Package
- Implementing Error Handling
- (Level 300) Debugging a Package
- (Level 300) Implementing Error Handling
- (Level 300) Controlling Failure Behavior
After completing this module, students will be able to:
- Debug an SSIS package.
- Implement error handling.
- Implementing Checkpoints
- Implementing Transactions
- (Level 200) Implementing Checkpoints in a Package
- (Level 300) Implementing Transactions in a Package
- (Level 300) Implementing a Native Transaction
After completing this module, students will be able to:
- Implement checkpoints.
- Implement transactions.
- Package Configurations
- Deploying Packages
- (Level 200) Creating a Package Configuration
- (Level 200) Preparing a Package for Deployment
- (Level 200) Deploying a Package
After completing this module, students will be able to:
- Implement package configurations.
- Deploy packages.
- Managing Packages
- Securing Packages
- (Level 200) Importing a Package
- (Level 200) Configuring and Monitoring a Package
- (Level 200) Scheduling a Package
- (Level 200) Securing a Package
After completing this module, students will be able to:
- Manage packages.
- Secure packages.
- Exposure to enterprise data import and export scenarios.
- Experience navigating the Microsoft Windows Server environment.
- Experience with Microsoft SQL Server, including:
- SQL Server Agent.
- SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
- SQL Server System tables.
- SQL Server accounts (users and permissions).
Instructors
Adam Keats
With over 24 years of real-world and training experience, Adam is ...