|
SQL Server 2005, 2008, 2008R2, 2012, 2014 |
SQL Server 2005, 2008, 2008R2, 2012, 2014 |
| All Downloads ----- Join VIP ----- Questions? | SSIS+ 1.7 Beta Now Open |
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.