Trace Id is missing

Unlock your potential with Microsoft Copilot

Get things done faster and unleash your creativity with the power of AI anywhere you go.
Download the Copilot app
Microsoft Copilot app being utilized to generate pictures of a singing dog, assisting to identify a flower, and helping to generate an email to congratulate a coworker on a promotion.

Microsoft® SQL Server Integration Services Balanced Data Distributor

Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    v1.0

    Date Published:

    16/08/2012

    File Name:

    License_ SQL Server Integration Services Balanced Data Distributor Transformation.docm

    BalancedDataDistributor-x86.msi

    BalancedDataDistributor-x64.msi

    File Size:

    48.4 KB

    1.3 MB

    1.7 MB


    Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform. 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.

    NOTE:  An updated version of Microsoft SSIS Balanced Data Distributor (BDD) is available. This includes a fix for the problem causing BIDS to crash when removing the BDD transform. For more details, and download information, see KB 2616527.

    For a demonstration of the SSIS Balanced Data Distributor, see the Balanced Data Distributor (SQL Server Video).

    For a discussion of when to use the SSIS Balanced Data Distributor, refer this link.

  • Supported Operating Systems

    Windows 7, Windows Server 2008 R2


    SQL Server 2008 or SQL Server 2008 R2


    1. Please note By downloading the product you are accepting all conditions that are outlined in the EULA (End User License Agreement) located on this page.


    2. Please read the EULAs on this page, once completed please download the appropraite file (X86 or X64 version of the software).


    3. In order to design an SSIS package, you have to install Business Intelligence Development Studio (BIDS). This is a 32-bit application even if the SQL Server is 64-bit.


    4. Some tools such as dtexec.exe have both 32-bit and 64-bit versions under 64-bit installation of SQL server.


    5. Refer to the following article for more information on 64 bit considerations for Integration Services - http://msdn.microsoft.com/en-us/library/ms141766.aspx


    6. Once you have installed BDD, you will need to open the SSIS template in BIDS, right click on toolbox, select “Choose Items…”, go to “SSIS Data Flow Items” tab, check “Balanced Data Distributor” and hit OK. “Balanced Data Distributor” should now be in the toolbox in the “Transformation” section, ready to be used.

Back To Top