Integration Services Administrator InfoCenter

In Microsoft Integration Services, an administrator maintains and optimizes solutions and projects at an operational level. Because these maintenance and optimization tasks are wide ranging, an Integration Services administrator may be known by a variety of job titles: Database Administrator, Report Server Administrator (Corporate IT), Security Expert, Data Warehouse Administrator, or Lead Database Administrator.

To help the Integration Services administrator be as effective as possible, the following lists provide links to those topics considered most useful to the maintenance and optimization of Integration Services solutions.

SQL Server Integration Services Security Overview (Integration Services) Integration Services Packages Migrating Earlier Versions of Packages Integration Services Backward Compatibility Upgrading Integration Services Packages Support for Data Transformation Services (DTS) in SQL Server 2008 Migrating Data Transformation Services Packages Saving and Running Packages Saving Packages Backing Up and Restoring Packages Running Packages Scheduling Package Execution in SQL Server Agent Using Checkpoints in Packages Monitoring Package Execution Integration Services Service Monitoring the Performance of the Data Flow Engine Deploying Packages Creating Package Configurations Creating a Deployment Utility Deploying Packages by Using the Deployment Utility Redeploying Packages

More InformationOverview (Integration Services)Installing Integration Services Considerations for Installing Integration Services Considerations for Upgrading Integration Services Considerations for Upgrading Data Transformation Services Installing SQL Server Components Considerations for Installing the SQL Server Database Engine Considerations for Installing Analysis Services Considerations for Installing Reporting Services Tutorials and Samples Tutorial: Creating a Simple ETL Package How Do I Find Samples (Integration Services) Integration Services Security Security Overview (Integration Services) Using Integration Services Roles 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.