SQL Server - Integration Services (SSIS)

About

It is a platform for ETL operation (Developed by MicroSoft).

SSIS is (a feature of|included with) SQL Server (introduced in 2005 is the new DTS (Data Transaction Services) platform).

Articles Related

Installation

SSIS consists of a Windows® service that is installed when you select Integration Services on the Feature Selection page of the SQL Server setup wizard.

A screen of the SQL Server Data Tool (ie the design tool of Visual Studio for SSIS, SSAS and SSRS)

Service

The SSIS Windows® service is primarily a control flow engine that manages the execution of task workflows. Task workflows are defined in packages. When developing an SSIS package, the task workflow is referred to as the control flow of the package.

Flow

SSIS - Data Flow (from source to destination). The data flow is the real unit of execution where you can set the number of threads.
SSIS - Control Flow (Workflow). The workflow

Client

In addition to the SSIS Windows service, SSIS includes:

SSIS Designer.
Wizards.
Command-line tools. To manage and execute SSIS packages.

Wizard

Create, configure, and deploy SSIS solutions with a wizard.

Designer

A graphical design interface for developing SSIS project and package in the Microsoft Visual Studio® development environment.

The Event Handlers tab. A graphical design surface where you can define the workflow for an event handler within a package.

Semantic

Application

An SSIS application usually consists of one or more SSIS projects, each containing one or more SSIS packages.

Project

A versioned container for parameters and packages
A unit of deployment to an SSIS catalog

One project may include one of several packages.

File extension: dtproj

Package

A package defines a workflow of tasks to be executed

An unit of task flow execution
An unit of deployment (package deployment model)

Management

Privileges

The DCOM Configuration tool (Dcomcnfg.exe) grant permission to specific users to use SSIS.