What are SQL Server Integration Services
Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration
solutions, including extraction, transformation, and load (ETL) packages for data warehousing. Integration Services
replaces Data Transformation Services (DTS), which was first introduced as a component of SQL Server 7.0.
SSIS includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions
such as FTP operations, for executing SQL statements, or for sending e-mail messages; data sources and destinations for
extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management service,
the Integration Services service, for administering Integration Services; and application programming interfaces (APIs)
for programming the Integration Services object model.
SQL Server Integration Services Architecture
Microsoft SQL Server 2005 Integration Services (SSIS) consists of four key parts:
- Integration Services Service: available in SQL Server Management Studio, monitors running Integration
Services packages and manages the storage of packages.
- Integration Services Object Model: includes managed application programming interfaces (API) for
accessing SQL Server Integration Services tools, command-line utilities, and custom applications.
- Integration Services Runtime saves the layout of packages, runs packages, and provides support for
logging, breakpoints, configuration, connections, and transactions. The SQL Server Integration Services run-time
executables are the package, containers, tasks, and event handlers that Integration Services includes, and custom tasks.
- Integration Services Data Flow encapsulates the data flow engine which provides the in-memory buffers
that move data from source to destination, and calls the sources that extract data from files and relational
databases. The data flow engine also manages the transformations that modify data, and the destinations that load
data or make data available to other processes. SQL Server Integration Services data flow components are the
sources, transformations, and destinations that Integration Services includes. Custom components can also be included in a data flow.
Click here to go back to the SQL Server content index page.
|