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. |