Flow Synchronization

Overview

The Flow Synchronization Component is an SSIS Data Flow Component which makes two or more data flows run at the same speed. This is accomplished by stopping one data flow if the others run too slow relative to it. It is a convenient companion to the Table Difference component, resolving problems with memory consumption. It can, however, be used on its own for any situation in which you want data flows to run at the same speed. The component uses semaphores to handle synchronization, resulting in very efficient CPU utilization.

Setup

Use the parameters below to set up the Flow Synchronization component for processing.

Parameters

Name

Specify the synchronization name.

Name from variable

The synchronization name is specified in the package variable.

Max delta

The maximum number of rows of difference between data flows.