This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading.

The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion.

It’s balanced and synchronous so if one of the downstream transforms or destinations is slower than the others, the rest of the pipeline will stall so this transform works best if all of the outputs have identical transforms and destinations.

The intention of BDD is to improve performance via multi-threading.

Several characteristics of the scenarios BDD applies to:

1) the destinations would be uniform, or at least be of the same type.

2) the input is faster than the output, for example, reading from flat file to OleDB.

Now Lets try Installed BDD on my machine and see how it works

How to Install BDD

Download MSI and install BDD in following steps :

Double click on this icon and installed BDD on your machine by following simple steps

Accept agreement !!

Click to Install

It will be installed as SQL Server Component as shown :

Click on Finish once done successfully!

How to use BDD

After successful installation if we open our SSDT environment we can see BDD component is available for all its use as shown

Features of BDD

The BDD transform makes it easy to split your data flow up on a buffer-by-buffer basis. The two primary scenarios for it are when you want to do parallel inserts into a destination…