SSIS Microsoft Balanced Data Distributor(BDD)

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.

The BDD

BDD

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.

System Requirements:

  • Windows 7, Windows server 2008 R2.
  • SQL Server 2008 and SQL Server 2008 R2.
Advertisements

About Zaim Raza

7 Years of professional experience in Business intelligence using SQL Server and Microsoft SharePoint/.net Technologies. Experience in Data warehousing, Data Modeling, Data profiling, Data Integration, Data cleansing, consultations and enterprise reporting. I want to work for organization where I am able to utilize my skills, experience and knowledge to transform the technology into business value.
This entry was posted in SSIS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s