FlowSync is a component that will make two or more flows of data in an SSIS data flow package run at the same speed, by stopping one flow if the others run too slow.
The project is freeware, full source code is available.
It has been created as a convenient companion to TableDifference to resolve the problems with memory occupation, it can be used by its own in the case where you want flows to run at the same speed.
It makes use of semaphores to handle synchronization, so no CPU is ever wasted, when the faster flows is stopped all the CPU is free for others (more useful) processes.
Now available from CozyRoc!
As of January 1, 2010 FlowSync component is now part of CozyRoc SSIS+ 1.4 library and can be downloaded from the following link: http://www.cozyroc.com/products
All support and enhancement questions should be addressed with the CozyRoc team.
Important notes to FlowSync users
Users who downloaded FlowSync until December 31, 2009 are using a freeware project with full source code. Thus, they can continue using this component without any issue.
Starting from January 1, 2010 the FlowSync component is no longer available from SQLBI. In the last 4 years (first version of FlowSync has been released in 2006) we have seen a large adoption of FlowSync and many companies requested us fixes and support. SQLBI is a consulting company and is not structured to provide full support services for SSIS components. Thus, we moved full rights on source code to CozyRoc, which is a company focused only on developing and supporting SSIS components. They will be able to give a full support to companies using FlowSync in a production environment, and this is something that several customers asked us in the past.
If your company is already using an old free version of FlowSync, you can continue to use it for free. However, moving to the new CozyRoc version will grant you access to full support and to a broader set of SSIS components.