Export (0) Print
Expand All
60 out of 193 rated this helpful - Rate this topic

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 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.

Integration Services replaces Data Transformation Services (DTS), which was first introduced as a component of SQL Server 7.0.

Information worker icon Integration Services Information Worker InfoCenter Provides information for package designers who build data transformation solutions using the graphical tools that Integration Services provides.
Administrator icon Integration Services Administrator InfoCenter Focuses on quickly getting the database administrator familiar with the installation and maintenance of Integration Services packages.
Developer icon Integration Services Developer InfoCenter Provides an overview of the technologies and languages needed to implement an embedded data transformation solution.
Database architect icon Integration Services Architect InfoCenter Gives a broad view of the data transformation domain and describes how Integration Services can be effectively used in business intelligence solutions.
Integration Services icon Integration Services Overview An introduction to the Integration Services features and architecture.

Component interfaces with Integration Services

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.