Integration Services Information Worker InfoCenter

In Microsoft Integration Services, 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 Getting Started (Integration Services) Introducing Packages Integration Services Packages Control Flow Elements Data Flow Elements Understanding the Components of an Integration Services Package Creating Packages Creating an Integration Services Project Designing Packages in Business Intelligence Development Studio Using the SQL Server Import and Export Wizard to Move Data Adding Features to Packages Implementing Logging in Packages Using Property Expressions in Packages Using Variables in Packages Creating Package Configurations Restarting Failed Packages by Using Checkpoints Ensuring Data Integrity by Using Transactions Troubleshooting Packages Debugging Control Flow Debugging Data Flow Deploying Packages Package Deployment (Integration Services) Languages Used by Integration Services Transact-SQL Reference (Database Engine) Integration Services Expression Reference

More InformationOverview (Integration Services)Installing Integration Services Considerations for Installing Integration Services Considerations for Upgrading Data Transformation Services Known DTS Package Migration Issues Installing SQL Server Components Considerations for Installing the SQL Server Database Engine Considerations for Installing Analysis Services Considerations for Installing Reporting Services Tutorials and Walkthroughs SSIS Tutorial: Creating a Simple ETL Package How Do I Find Samples (Integration Services) Integration Services Security Setting the Protection Level of Packages Using Digital Signatures with Packages Troubleshooting Integration Services Troubleshooting Concepts (Integration Services) External Resources SQL Server TechNet

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.