SQL Server - Integration Services (SSIS)
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).
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.
- 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
In addition to the SSIS Windows service, SSIS includes:
- SSIS Designer.
- Command-line tools. To manage and execute SSIS packages.
Create, configure, and deploy SSIS solutions with a wizard.
- The Event Handlers tab. A graphical design surface where you can define the workflow for an event handler within a package.
An SSIS application usually consists of one or more SSIS projects, each containing one or more SSIS packages.
- 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
A package defines a workflow of tasks to be executed
- An unit of task flow execution
- An unit of deployment (package deployment model)
The DCOM Configuration tool (Dcomcnfg.exe) grant permission to specific users to use SSIS.