Integration Services Documentation Map
Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high-performance data integration solutions. You can build extract, transform, and load (ETL) packages to update data warehouses, interact with external processes, clean and mine data, process analytic objects, and perform administrative tasks.
Integration Services includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, SQL statement execution, and e-mail messaging; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management service called the Integration Services service for administering Integration Services; and application programming interfaces (APIs) for programming the Integration Services object model.
Integration Services Documentation
For more information about Integration Services, see these sections of SQL Server Books Online.
| Section | Description |
|---|---|
Provides an overview of the relationship between Integration Services and other SQL Server 2005 components, and includes links to role-based Integration Services InfoCenters. |
|
Describes typical uses of Integration Services, provides an overview of the Integration Services architecture and tools. |
|
Describes how to install Integration Services by using Setup or from the command prompt. |
|
Discusses the objects that Integration Services provides for constructing robust control flow and data flow in packages. Introduces the more advanced objects that make packages more flexible and easier to manage and troubleshoot. |
|
Integration Services in Business Intelligence Development Studio |
Describes the Business Intelligence Development Studio environment that you will use to develop Integration Services packages for data extraction, transformation, and loading (ETL). |
Introduces solutions and projects. Describes how you use the Integration Services project to manage objects in an ETL solution. |
|
Provides walkthroughs for common tasks, basic as well as advanced, that you perform in the development of an ETL solution. |
|
Provides tutorials that teach you how to create a basic package by using the SQL Server Import and Export Wizard, create a more complex package from scratch, and deploy packages to a target server |
|
Includes the topics that describe the Integration Services samples. The samples are ready-to run packages or sample code for custom tasks, data flow components, log providers, and connection managers. |
|
Provides conceptual programming information, lots of sample code, and documents the Integration Services API. |
|
Discusses the new Integration Services expression language and provides documentation of the operators and functions in the language. |
|
Provides information about configurations and how you implement them in packages, how you build the deployment utility, and the steps to install packages on a target computer. |
|
Describes the security-related properties that you can set on packages and the fixed database-level roles for controlling access to packages. |
|
Provides information about Integration Services service and how to use it to manage packages, how to run packages on demand or schedule, and how to load balance by running packages on remote servers. |
|
Provides information about troubleshooting Integration Services by using the features and tools that Business Intelligence Development Studio provides as well as information about designing, monitoring performance in packages, and managing the Integration Services service. |
|
Explores the relationship between Integration Services and other SQL Server 2005 components, including detailed information about Integration Services objects that are tailored for use with specific components. |
|
Provides step-by-step instructions for accomplishing tasks in Integration Services. |
|
Provides detailed information about the options on every page and dialog box in Integration Services. These topics can also be displayed by pressing the F1 key or the Help button while working with the Integration Services tools. |
|
Discusses Integration Services features that support the parsing and manipulation of multilingual data and the special comparison options for sorting and comparing international string data. |
|
Contains reference information for the dtexec command prompt utility. |
|
Contains reference information for the dtutil command prompt utility. |
Another avenue into the documentation is via SQL Server Integration Services (How Do I), which provides links to common tasks and frequently-accessed conceptual information.
See Also
Concepts
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|