Flow Synchronization

Overview

Flow Synchronization is 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. It is convenient companion to Table Difference component, resolving problems with memory consumption. However it can be used on its own, in case you want data flows to run at the same speed. The component uses semaphores to handle synchronization, resulting in very efficient CPUs utilization.

Setup

Use the options below to setup Flow Synchronization component for processing.

Options

Name

Specify synchronization name.

Name from variable

Synchronization name is specified in package variable.

Max delta

Maximum number of rows of difference between data flows.

PASS Summit '10

November 8 - 11, 2010 Washington State Convention & Trade Center in Seattle, WA

CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Visit CozyRoc at booth #425 and say HI. Register with code CR3D and get $100 off.

CozyRoc SSIS+ has been nominated for the 2010 SQL Server Magazine Community Choice Awards, category "Best Business Intelligence & Reporting Product". Vote Now to help us win this prestigious award.