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 slowly.
The project is freeware – the full source code is available.
It was created as a convenient companion to TableDifference to resolve the problems with memory occupation. It can be used on its own in case you want flows to run at the same speed.
It uses semaphores to handle synchronization, so no CPU is ever wasted. When the faster flows is stopped all the CPU is free for other, more useful processes.
Now available from CozyRoc!
As of January 1, 2010 the FlowSync component is now part of the CozyRoc SSIS+ 1.4 library and can be downloaded at the following link: http://www.cozyroc.com/products
All support and enhancement questions should be addressed to the CozyRoc team.
Important notes for FlowSync users
Users who downloaded FlowSync prior to 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 – the first version of FlowSync was released in 2006 – we have seen a large adoption of FlowSync and many companies requested fixes and support from us. SQLBI is a consulting company and is not structured to provide full support services for SSIS components. Thus, we moved the full rights over the source code to CozyRoc, which is a company focused strictly on developing and supporting SSIS components. They will be able to provide full support to companies using FlowSync in a production environment, and this is something that several customers had asked from us in the past.
If your company is already using an older, 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 services and to a broader set of SSIS components.