SQL Server 2008 Integration Services (SSIS) Training

  SSIS

• Understanding Integration Services 
• Exploring and Executing an SSIS Package in BIDS
• Exploring and Executing a Package outside of  BIDS

Introduction to Control Flow

• Overview of Control Flow in Integration Services 
• Working with Workflow Tasks
• Precedence Constraints

 Data Flows

• The Data Flow Task
• Work on Execute SQL Task
• Work on Bulk Insert Task
• Work on File System Task
• Work on FTP Task
• Work on Send Mail Task
• Grouping & Looping of Containers
• Work on Web Service Task
• Work on WMI task List
• Work on Analysis Services task List
• Work on Execute Process & Package Task
• Data Viewers
• Data Viewer
• Data Flow Transformations
• Transform Data
• Data Transformations : Copy Column Transformation
• Data Transformations : Derived Column Transformation
• Data Transformations : Data Conversion Transformation
• Data Transformations : Conditional Split Transformation
• Data Transformations : Aggregate Transformation
• Data Transformations : Sort Transformation
• Data Flow Transformations(Advanced)
• Transform Data
• Lookup Transformations : Copy Column Transformation
• Fuzzy Lookup & Fuzzy Grouping Transformation
• Multicast Transformation
• Merge & merge join Transformation
• Data Mining Query Transformation
• SCD Transformation
• Cache Transformation

 

Variables and Configurations

• Understanding Variables
• Using Variables in Control Flow
• Using Variables in Data Flow
• Configurations
• Using Variables and Configurations between Packages

 

 

Advanced Control Flow

• Advanced Control Flow Overview
• Using Containers
• Transactions Support in Integration Services 

Error Logging and Handling

• When Things Go Wrong
• Checkpoints
• Handling Errors and Debugging
• Packaging Logging
• Event Handling

 

Advanced Data Flow

• Synchronous and Asynchronous Transformations
• Using Advanced Transformations
• Handling Slowly Changing Dimensions
• Data Mining

 

Package Deployment

• Deploying Packages
• Create a Package Deployment Utility
• Installing a Package
• Redeploying Updated Packages

Package Management

• Overview of Package Management
• Managing Integration Services Packages
• Executing Packages
• Integration Services Security

Scripting and Custom Components

• Extending SSIS Capabilities Through Code
• Scripting in Control Flows with the Script Task
• Scripting in Data Flows with the Script Component
• Custom SSIS Components

Best Practices

• Best Practices for Using Integration Services 
• Best Practices for Package Development and Design 
• Data Flow Best Practices
• Deployment and Management Best Practices