SSIS Architecture

  • Packages – A package is a collection of tasks framed together with precedence constraints to manage and execute tasks in an order. It is compiled in a XML structured file with .dtsx extension.
  • Control Flow – It acts as the brain of a package.It consists of one or more tasks and containers that executes when package runs. Control flow orchestrates the order of execution for all its components.
  • Tasks – A task can best be explained as an individual unit of work.
  • Precedence Constraints – These are the package components that connect the tasks together and manage the order in which the tasks will execute.
  • Host Containers – The Control flow tab (window) is itself host Container.
  • Containers – Core units in the SSIS architecture for grouping tasks together logically into units of work are known as Containers.
  • Connection Managers – Connection managers are used to centralize connection strings to data sources and to abstract them from the SSIS packages. Multiple tasks can share the same Connection manager.
  • Data Flow – The core strength of SSIS is its capability to extract data into the server’s memory (Extraction), transform it(Transformation) and write it out to an alternative destination(Loading).
  • Sources – A source is a component that you add to the Data Flow design surface to specify the location of the source data.
  • Transformations – Transformations are key components within the Data Flow that allow changes to the data within the data pipeline.
  • Destinations – Inside the Data Flow, destinations consume the data after the data pipe leaves the last transformation components.
  • Variables – Variables can be set to evaluate to an expression at run time.
  • Parameters – Parameters behave much like variables but with a few main exceptions.
  • Event Handlers – The event handlers that run in response to the run-time events that packages, tasks, and containers raise.
  • Log Providers – Logging of package run-time information such as the start time and the stop time of the package and its tasks and containers.
  • Package Configurations – After development your package and before deploying the package in production environment from UAT you need to perform certain package configurations as per production Server.


Hope you will like this post on Microsoft SQL Server.

If you really like reading my blog and understood at least few thing then

please don’t forget to subscribe my blog.

Connect With me on

| linkedIn | Google+ | WordPress |


One thought on “SSIS Architecture

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s