Microsoft SQL Server Integration Services

Microsoft SQL Server Integration Services (SSIS) is a comprehensive data integration platform that is used to transport, call, transform, and consolidate information from disparate sources and to upload it to several different systems. It is the successor to Data Transformation Services (DTS).

The SSIS is primarily intended for data integration tasks.

The following diagram shows the components of Microsoft SQL Server Integration Services in the integration blueprint:

Microsoft SQL Server Integration Services

The following table holds a description of the components of SQL Server Integration Services, as shown in the preceding diagram:

Component ...

Get Service-Oriented Architecture: An Integration Blueprint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.