Integration Services Information Worker InfoCenter

In Microsoft SQL Server 2005 Integration Services (SSIS), a knowledge worker fulfills the traditional "domain expert" role in business intelligence—someone who understands the data employed by a solution and is able to translate the data into business information. Often, the knowledge worker is the one analyzing the business to identify problems, opportunities, or project characteristics. The variety in expertise offered by a knowledge worker results in job titles such as Report Consumer (Business Analyst), Report Consumer (Manager), Technical Trainer, Help Desk/Operation, or Network Administrator.

To help the knowledge worker be as effective as possible, the following lists provide links to topics concerning the design, creation, and configuration of Integration Services packages.

Integration Services Integration Services Enhancements Introducing Packages Integration Services Packages Control Flow Elements Data Flow Elements Integration Services Objects and Concepts Creating Packages Building Solutions and Integration Services Projects Creating Packages in SSIS Designer Creating Packages Using the SQL Server Import and Export Wizard Adding Features to Packages Implementing Logging in Packages Using Property Expressions in Packages Using Variables in Packages Creating Package Configurations Using Checkpoints in Packages Incorporating Transactions in Packages Troubleshooting Packages Debugging Control Flow Debugging Data Flow Deploying Packages Deploying Integration Services Packages Languages Used by Integration Services Transact-SQL Reference (Transact-SQL) Integration Services Expression Reference

More InformationIntegration Services OverviewInstalling Integration Services Installing SQL Server Integration Services Upgrading or Migrating Data Transformation Services Known Package Migration Issues Installing SQL Server 2005 Components Installing the SQL Server Database Engine Installing SQL Server Analysis Services Installing SQL Server Reporting Services Tutorials and Walkthroughs Creating a Simple ETL Package Tutorial Package Samples Integration Services Security Setting the Protection Level of Packages Signing Packages with Certificates Troubleshooting Integration Services Troubleshooting Integration Services External Resources SQL Server TechNet