Architecture of SSIS

Any data integration/transformation solution you build using SSIS typically includes one/more projects. A project is a pool of packages. A package contains the tasks necessary to perform the actual extract, transform, and load (ETL) operations. Each package is saved as a .dtsx file and is part of a project. You can include one or more packages in a project.

Figure 1 : Architecture of SSIS

SSIS manages solutions, packages and projects using the following core components of its architecture:

  • The Integration Services service
  • The Integration Services object model
  • The Integration Services runtime and the run-time executables;
  • The Integration Services Data Flow.

The Integration Services service, available in SQL Server Management Studio, monitors running Integration Services packages and manages the storage of packages . The Integration Services object model includes managed application programming interfaces (API) for accessing Integration Services tools, command-line utilities, and custom applications. The Integration Services runtime saves the layout of packages, runs packages, and provides support for logging, breakpoints, configuration, connections, and transactions. The Integration Services run-time executables are the package, containers, tasks, and event handlers that Integration Services includes, and custom tasks.