Tags: 
1.4, Component, Transformation

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

Specify the synchronization name.

The synchronization name is specified in the package variable.

The maximum number of rows of difference between data flows.