Servers

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

    Language:
    English
    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.
    • Details
      Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      v1.0

      File Name:

      ENG\Microsoft Balanced Data Distributor For SQL Server 2012 License Terms.docx

      BalancedDataDistributor-x64.msi

      ENG\x86\BalancedDataDistributor-x86.msi

      Date Published:

      7/8/2012

      File Size:

      28 KB

      1.6 MB

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

        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 System

      Windows 7, Windows 8 Consumer Preview, Windows Server 2008 R2 SP1


        SQL Server 2012

        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.


    • Additional Information

    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 04

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 05

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial