Learn to maximize the numerous features of SSIS from this essential video guide. This multimedia course makes learning SSIS easy through the use of extensive practical, real-world exercises structured around every component within Business Intelligence Development Studio. You will learn to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets, Oracle and DB2 databases, and transform the data for OLAP analysis, mining, and reporting.

• Build robust, high-performance Business Intelligence solutions with SSIS visual package designer.
• Extract, transform, and load (ETL) data from disparate sources and move it to single or multiple destinations using SSIS data flow transformations.
• Step-by-step how to build, manage and deploy sophisticated SSIS packages, draw out meaningful information from raw data, and deliver data to web business applications and enterprise reports.
• Learn migrating DTS packages to SSIS, enhancing performance, and implementing encryption policies to secure SSIS packages.
• Build packages with the easy-to-use SSIS Import and Export Wizard and the Visual Studio based BIDS.
• Create expressions using variables, functions, and operators.
• Lay out package workflow with control flow containers and tasks.
• Monitor and audit runtime events using log providers.
• Respond to external triggers with event handlers.
• Process input using Data Flow tasks.
• Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations.
• Load data warehouse using Slowly Changing Dimension transformation.
• Deploy, optimize, troubleshoot, and debug SSIS packages.
• Learn about XML configuration file, deployment security and the manifest file.
• Discover all SSIS command prompt utilities.

CD-ROM 1 - INTEGRATION SERVICES
1. Welcome to SSIS: Data Transfer by Flowcharting
2. New Features in Integration Services
3. SSIS Package Architecture
4. Design and Management Tools
5. Configuring, Deploying & Maintaining Packages
6. Setting up Integration Services
7. The SSIS Import and Export Wizard
8. Exporting Data OUT from the Database
9. Importing Data IN to the Database
10. Business Intelligence Development Studio
11. Designing Your First Package
12. Executing a Package in Management Studio
13. Migrating DTS 2000: Package Migration Wizard
14. SSIS Sample Packages & Metadata Management
15. SSIS as ETL Tool for Data Warehouses
16. Automating with SSIS Command Prompt Utilities

CD-ROM 2 - BIDS
1. Navigation in BIDS - Navigation Pane
2. Standard Project Templates & Tasks
3. SSIS Menu, Debugging & Diagnostics Windows
4. Solution Explorer & Properties Window
5. The SSIS Package Designer
6. The Toolbox & Options Dialog Box
7. Connection Manager
8. The Variables Window & The Package Explorer
9. Find and Replace in Files
10. Control Flow Basics
11. The Execute DTS 2000 Task
12. The Execute Process Task
13. The Execute SQL Task
14. The Bulk Insert Task
15. The File System Task
16. The Send Mail Task

CD-ROM 3 - CONTAINERS
1. Grouping and Looping
2. For Loop Container
3. For Each Container
4. The Sequence Container
5. Precedence Constraints
6. The WMI & Web Service Tasks
7. The FTP Task
8. The ActiveX Script Task
9. The Script and XML Tasks
10. The Execute Package Task
11. Transfer SQL Server Objects Task
12. Database Maintenance Plan
13. Execute SSA Job & Maintenance Plan Tasks
14. The Execute T-SQL Statement Task
15. The Backup Database & Notify Operator Tasks
16. The Rebuild Index & Update Statistics Tasks

CD-ROM 4 - DATA FLOW
1. Data Flow Overview
2. Data Flow Sources
3. Data Flow Transformations
4. Data Flow Destinations
5. Setting up Data Flow Viewers
6. The Copy Column Transformation
7. The Derived Column Transformation
8. The Export Column Transformation
9. The Import Column Transformation
10. The Data Conversion Transformation
11. The Conditional Split Transformation
12. The OLE DB Transformation
13. The Aggregate Transformation
14. The Sort & Character Map Transformations
15. The PIVOT & UNPIVOT Transformations
16. The Row Count & Row Sampling Transformations

CD-ROM 5 - VARIABLES
1. Variables Overview
2. Variable Scope
3. SSIS System Variables
4. Setting up Nested Iteration in Control Flow
5. Using Variables in Script Tasks
6. Mapping Parameters & Result Sets to Variables
7. System & User Variables in Property Expressions
8. Configuration Overview & Options
9. The Package Configuration Wizard
10. Debugging, Error Handling and Logging
11. Debug Breakpoints in SSIS Packages
12. BIDS Debugging Windows
13. Control Flow: The OnError Event Handler
14. Data Flow: Error Data Flow
15. Configuring Package Logging
16. Built-in Log Providers & Log Events

CD-ROM 6 - ADVANCED SSIS
1. The Lookup Transformation
2. Term Lookup & Term Extraction
3. Fuzzy Lookup and Fuzzy Grouping
4. The Multicast & Union All Transformations
5. The Merge and Merge Join Transformations
6. The Percentage Sampling & Audit Transformations
7. The Data Mining Query Task
8. The Slowly Changing Dimension Transformation
9. Extending SSIS through Custom Code
10. The SSIS Object Model & Script Editor
11. The Server Explorer in BIDS
12. Script in Data Flow: The Script Component
13. Advanced Sources & Destinations
14. Advanced Control Flow
15. Accessing Heterogenous Data
16. SSIS Performance Tuning Techniques

CD-ROM 7 - DEPLOYMENT
1. Configurations & Deployment
2. The XML Configuration File
3. Configuring Connection Managers
4. The MULTIFLATFILE Connection Manager
5. The Deployment Utility & Deployment Options
6. Deployment Security & The Manifest File
7. The Package Installation Wizard
8. Execute Package Utilities: DTExec & DTExecUI
9. Package Management & Import from Other Servers
10. Complex SSIS Import & Export Wizard in BIDS
11. The SSIS Service & Administration
12. Managing Packages with DTUtil
13. SQL Server 2005 Management Studio
14. Managing Packages with Management Studio
15. Scheduling Packages with SQL Server Agent
16. Top 10 SSIS Success Secrets