The Main SSIS Components

By

There are a number of core components that make up the SSIS GUI in the SSIS Designer. These include:

  • Control Flow – Control flows are parts of a package that provide structure, tasks, and precedence constraints.

  • Data Flow– Pull and transform data from a variety of sources on the device. Data flow components include sources, transformations, and destinations.

  • Event Handlers – Create tasks in response to events at run-time.

  • Package Explorer– View a top-down perspective of package elements.

  •         Connection Manager - Creates a link between the main data source and the package, connecting all defined components and data sources of the entire setup.




Comments

Post a Comment