Cover image for SQL Server Integration Services

Book description

SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources.

This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS).

Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios.

Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.

Table of Contents

  1. SQL Server Integration Services
    1. Getting Started
    2. Installation and Setup
    3. Key Concepts
      1. Packages
      2. Control Flow Elements
        1. Control flow containers
        2. Control flow tasks
        3. Maintenance plan tasks
        4. Precedence constraints
      3. Data Flow Elements
        1. Data flow sources
        2. Data flow transformations
        3. Data flow destinations
        4. Data flow paths
      4. Connections
      5. Event Handlers
      6. Variables
      7. Package Configurations
      8. Log Providers
    4. Developing Solutions
        1. Solution Explorer
        2. Designer
        3. Connection managers
        4. Toolbox
        5. Properties
        6. Variables
        7. Log Events
    5. Executing Packages
    6. Deploying Packages
    7. Migrating from Legacy
      1. Upgrade Advisor
      2. Execute DTS 2000 Package Task
      3. Package Migration Wizard
    8. Example 1: Data Flow
      1. Create an SSIS Project
      2. Create an SSIS Package
      3. Execute SSIS Packages
      4. Debugging
        1. Breakpoints
        2. Data viewer
    9. Example 2: Aggregation
    10. Example 3: Lookup
    11. Example 4: Data Type Conversion
    12. Example 5: Variables
    13. Example 6: Package Configuration
    14. Example 7: Looping and Control Flow
    15. Example 8: Logging
    16. Example 9: Error Handling
    17. About the Author