Microsoft introduced a new data flow transformation component is called Balanced Data Distributor (BDD) and you can download this component from here . It is a multithreaded component which equally split the data into the different multiple outputs. BDD take the advantage of multi core,multi-processor boxes, and also taking the advantage of SQL Server parallelism.BDD transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion. In contrast Multicast take 1 input dataset and from it generate n output datasets that are an exact copy of the input dataset.Following snapshot depicts the BDD behavior.
Description,LocaleID and ValidExternalMetaData are the properties which only you can use. To get the better performance, the same amount of work need to be done on all outputs due to the ‘’Balanced’’ Characteristic of this component.
- Windows 7, Windows server 2008 R2.
- SQL Server 2008 and SQL Server 2008 R2.