Explain the architecture of SSIS

The SSIS architecture is made up of four main components:

  • Integration Services: It monitors running Integration Services packages and accomplishes the storage of packages.
  • Integration Services object model: It contains a managed API for reading Integration Services tools, command-line utilities, and custom applications.
  • Integration Services run time and runtime executables: It keeps the layout of packages, runs the packages, and provides support for logging, breakpoints, configuration, connections, and transactions.
  • Dataflow Engine: It provides in-memory buffers that move data from source to destination.