Integration Services Architect InfoCenter

In Microsoft SQL Server 2005 Integration Services (SSIS), an architect decides the technologies to use for implementing a given Integration Services solution, and focuses on the interaction and interoperability of individual projects within a solution and individual solutions across the enterprise. As the solution-level decision maker, an architect provides vision and scope to projects within an Integration Services solution, and is known by job titles such as Data Warehouse Architect or Enterprise Data Architect.

To help the architect be as effective as possible, the following lists provide links to those topics considered most useful in understanding Integration Services, as well its interaction and interoperability with other services.

Integration Services Integration Services Enhancements SQL Server 2005 Components SQL Server Database Engine SQL Server Analysis Services SQL Server Reporting Services SQL Server Notification Services Service Broker Using Integration Services in Business Solutions Developing Business Intelligence Solutions Designing and Creating Integration Services Packages Integration Services Programming System Requirements Editions and Components of SQL Server 2005 Integration Services Considerations on 64-bit Computers Hardware and Software Requirements for Installing SQL Server 2005 Check Parameters for the System Configuration Checker Backwards Compatibility SQL Server 2005 Integration Services Backward Compatibility Working with Multiple Versions of SQL Server Migrating Data Transformation Services Packages International Considerations International Considerations for Integration Services

More InformationIntegration Services OverviewTutorials and Walkthroughs Creating a Simple ETL Package Tutorial Package Samples Security Security Considerations for a SQL Server Installation Security Considerations for Integration Services External Resources SQL Server TechNet