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

Description

Connection Managers

A Connection Manager is a logical representation of a connection.

SQL Server Integration Services provides a variety of different connection managers that packages can use to create connections with a range of data sources and servers.

The following connection types are supported, among others: ADO, ADO.NET, Excel, file, flat file, FTP, HTTP, MSMQ, MSOLAP, OLEDB, ODBC, and SMTP.

Control Flow Elements

SQL Server Integration Services provides three different types of Control Flow Elements:

  • Containers: Objects in SQL Server Integration Services that provide a structure. They support repeating control flows in packages and they group tasks and containers into meaningful units of work. Containers can include other containers in addition to tasks.
  • Tasks: Control flow elements that define units of work that are performed in a package control flow. A SQL Server Integration Services package is made up of one or more tasks. If the package contains more than one task, the tasks are connected and sequenced in the control flow by constraints. SQL Server Integration Services includes the following types of tasks:
    • Data flow tasks
    • Data preparation tasks
    • Workflow tasks
    • SQL server tasks
    • Scripting tasks
    • Analysis service tasks
    • Maintenance tasks
  • Precedence constraints: Constraints connect executables, containers, and tasks to form an ordered control flow.

Data Flow Elements

SQL Server Integration Services provides three different types of Data Flow components:

  • Sources: This component extracts data from data stores, such as tables and views in relational databases, files, and SQL Server Analysis Services databases.
  • Transformations: This component modifies, summarizes, and cleans data.
  • Destinations: This component loads data into data stores or creates in-memory datasets.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset