Data Modelling: Introduction to SQL Server Integration Services

• Datawarehousing Basics
• Product History
• SSIS Package Architecture Overview
• Development and Management Tools

Business Intelligence Development Studio

• Launching BIDS
• Project templates
• The package designer
• The Toolbox
• Solution Explorer
• The Properties window
• The Variables window
• The SSIS menu

Introduction to Control Flow and Data Flow

• Control Flow Overview
• precedence Constraints
• The Execute SQL Task
• The Bulk Insert Task
• The File System Task
• The FTP Task
• The Send Mail Task
• Containers – grouping and looping
• The Web Service Task
• The WMI tasks
• The Analysis Services tasks
• The Execute Process Task, Execute Package Task
• Data Flow Overview
• Data Sources
• Data Destinations
• Data Transformations
• The Copy Column Transformation
• The Derived Column Transformation
• The Data Conversion Transformation
• The Conditional Split Transformation
• The Aggregate Transformation
• The Sort Transformation
• Data Viewers

Variables and Configurations

• Variables Overview
• Variable scope
• SSIS system variables
• Using variables in control flow
• Using variables in data flow
• Using variables to pass information between packages
• Property expressions
• Configuration Overview
• Configuration options
• Configuration discipline

Debugging, Error Handling and Logging

• SSIS debugging overview
• Breakpoints in SSIS
• SSIS debugging windows
• Control Flow: The OnError event handler
• Data Flow: Error data flow
• Configuring Package Logging
• Built-in log providers

SSIS Using SQL Server Management Studio

• The Import and Export Wizard
• Importing and Exporting Data
• Scheduling and Executing Plans

Advanced Data Flow

• Revisiting data sources and destinations
• The Lookup Transformation
• Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
• The Multicast Transformation
• The Merge and Merge Join Transformations
• The Slowly Changing Dimension Transformation
• Transaction Handling in SSI
• Check Point configurations

Introduction to SSIS scripting

• The SSIS script editor
• The SSIS object model
• Script in Control flow: The Script Task
• Script in Data flow: The Script Component
• Introduction to SSIS component development

SSIS Package Deployment

• Configurations and deployment
• The deployment utility
• Deployment options
• Deployment security
• Executing packages – DTExec and DTExecUI

SSIS Package Management

• The SSIS Service
• Managing packages with DTUtil
• Managing packages with SQL Server Management Studio
• Scheduling packages with SQL Server Agent