Overview

An SSIS component is something that can exist within a SSIS Dataflow Task and which will do some of the following things:

  • Take data as an input
  • Carries out an operation on that data
  • Passes it on to another component

Examples of component operations are sorting, filtering, data transforming & aggregating; these are the most commonly-used although there are many more.