Flow Synchronization

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

All Downloads ----- Join VIP ----- Questions? SSIS+ 1.7 Beta Now Open


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.


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



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.