Microsoft Download Center Archive

Microsoft® SQL Server Integration Services Balanced Data Distributor For Microsoft® SQL Server® 2012

  • Published:
  • Version: v1.0
  • Category: Tool
  • Language: English

Microsoft® SSIS Balanced Data Distributor (BDD) is an SSIS data flow transformation component. This transformation takes a single input and uses multithreading to distribute the incoming rows uniformly to one or more outputs.


  • 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.

    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.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSize
BalancedDataDistributor-x64.msi
SHA1: 5ffbc035817bdb3a2dc9905ec5b002a227fc915f
625 KB
ENG/Microsoft Balanced Data Distributor For SQL Server 2012 License Terms.docx
SHA1: 9f30b9517eb8cb9b1a7101162072c309eaf524e8
24 KB
ENG/x86/BalancedDataDistributor-x86.msi
SHA1: 022d4e63178173bf6c2562bdd0f23c6050b8b61e
524 KB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012


  • SQL Server 2012

Installation Instructions


    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.