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).
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)
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.
In addition to the SSIS Windows service, SSIS includes:
Create, configure, and deploy SSIS solutions with a wizard.
A graphical design interface for developing SSIS project and package in the Microsoft Visual Studio® development environment.
An SSIS application usually consists of one or more SSIS projects, each containing one or more SSIS packages.
One project may include one of several packages.
File extension: dtproj
A package defines a workflow of tasks to be executed
The DCOM Configuration tool (Dcomcnfg.exe) grant permission to specific users to use SSIS.