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.