Chapter 14 Quick Reference

Open table as spreadsheet

This term	Means this
OVAL	OVAL is an acronym for the principles of package design for four key facets of SSIS applications. These design considerations include identifying the Operations to be performed; the data Volume to be processed (in production); the Application of the right tools, tasks, sequence, and flow; and the Location-determining where the SSIS application will run.
Synchronous tasks	Transformation tasks that process input rows and send output rows down-stream in the data pipeline a row at a time. Examples include derived columns, transformed data types, multicast, and Conditional Split.
Asynchronous tasks	Transformation tasks that process all the input rows before they send output rows downstream in the data pipeline a row at a time. Examples include the Sort task and Aggregate task.
Master-child packages	A design technique used to control package execution sequence, using the Execute Package control flow task. The master package controls the sequence and execution of one or more child packages.