SSIS Contents

1. Introduction and overview of SQL Server Integration Services
    - SSIS Package Architecture Overview
    - Development and Management Tools and SSIS Packages.
    - Source Control for SSIS Packages

2. SSIS for SSMS concepts
    - The Import and Export Wizard
    - Importing and Exporting Data
    - Working with Packages
    - Database Maintenance Plans
    - Creating Database Maintenance Plans using SSMS
    - Scheduling and Executing Plans

3. Business Intelligence Development Studio
    - Launching BIDS
    - Project templates
    - The package designer
    - The Toolbox and Solution Explorer

4. Working with Control 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
    - Execute Process Task and Execute Package Task

5. Introduction to Data Flow
    - Data Flow Overview, Sources, Destinations and Transformations.
    - Copy Column Transformation
    - Derived Column Transformation
    - Data Conversion Transformation
    - Conditional Split Transformation
    - Aggregate Transformation
    - Sort Transformation
    - Data Viewers

6. Variables and Configurations
    - SSIS system variables
    - variables in control flow
    - variables in data flow
    - Configuration Overview
    - Configuration options

7. Debugging, Error Handling and Logging
    - Debugging package
    - Implementing handling

8. Implementing Checkpoints and transactions
    - Implementing Checkpoints
    - Implementing Transactions

9. SSIS Administration
    - Deploying Packages
    - Managing Packages
    - Securing Packages
    - Scheduling a Package