Customized and On Site Training Available
View our White Papers
Click here for SQL Server Developer training
This course will enable technology
professionals with little or no ETL
experience and minimal exposure to SQL
Server and Visual Studio to be
comfortable and productive with the SSIS
tools and technologies. In this course you
will learn about the SQL Server Management
Studio (SSMS). You will be introduced
to the Business Intelligence Development
Studio (BIDS) and working with Control
Flow and Data Flow, variables and configurations. You will also become
familiar with SSIS package management and
package deployment along with learning to
write solid code using debugging, error
handling and logging techniques.
|
SQL Server 2005 versus 2008
This course applies equally to Integration Services in both SQL Server 2005 and SQL Server 2008.
All topics are applicable to both versions because for the functionality covered by this course,
the versions are identical. The instructor will point out the minor differences during class.
Everything covered in this class applies to both versions.
|
Prerequisites
This course assumes no prior knowledge of
SQL Server Integration Services. This
course does assume prior knowledge of SQL
Server and basic use of SQL Server
Management Studio. Other tools used in
this course include Notepad, Microsoft
Excel, and basic features of Windows.
A Guided Tour of SSIS
- Understanding SSIS
- Exploring and Executing an SSIS Package in BIDS
- Exploring and Executing a Package in BIDS
Introduction to Control Flow
- Overview of Control Flow in SSIS
- Control Flow Tasks
- Workflow Tasks
- Other SQL Server Operations Tasks
- Precedence Constraints
- Data Processing Tasks
Introduction to Data Flows
- Data Flow Overview
- Data Flow Pipeline
- Data Flow Sources
- Data Flow Destination
- Data Viewers
- Data Flow Transformations
Variables and Configurations
- Understanding Variables
- Using Variables in Control Flow
- Using Variables in Data Flow
- Understanding Property Expressions
- Using Property Expressions
- Understanding Configurations
- Using Configurations
- Using Variables and Configurations between Packages
Advanced Control Flow
- Advanced Control Flow Overview
- Using Containers
- Transactions Support in SSIS
- Additional Control Flow Tasks
Error Logging and Handling
- Error Logging and Handling Overview
- Checkpoints
- Package Logging
- Event Handling
Advanced Data Flow
- Synchronous Transformations
- Asynchronous Transformations
- Working with Error Outputs
- Using Advanced Transformations
Package Deployment
- Overview of Deploying Packages
- Deployment Challenges
- Create a Package Deployment Utility
- The Package Installation Wizard
- Deploy a Package to the File System
- Deploy a Package to SQL Server
- Redeploying Updated Packages
Package Management
- Overview of Package Management
- Managing Packages with DTUtil
- Managing Packages with SQL Server Management Studio
- Executing Packages
- Scheduling Packages with SQL Server Agent
- SSIS Security
Introduction to Scripting and Custom Components
- Extending SSIS Capabilities Through Code
- The SSIS Scripting
- Scripting in Control Flows
- Scripting in Data Flows
- Script Compilation
- Custom SSIS Components
Best Practices
- Best Practices for Using SSIS
- Best Practices for Package Design
- Data Flow Best Practices
Beyond ETL: Other Scenarios for SSIS
- Using SSIS Beyond ETL
- Migrating SQL Servers with SSIS
- SQL Server Maintenance Plans
- Working with Analysis Services
- Folder and File Management
- Working with the Windows Event Log
|
|
|
| 
