Microsoft Balanced Data Distributor For SQL Server 2012

Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform.
Download

Microsoft Balanced Data Distributor For SQL Server 2012 Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Freeware
  • Publisher Name:
  • Microsoft
  • Publisher web site:
  • Operating Systems:
  • Windows 7 / 2008 R2 / 8 32-bit
  • File Size:
  • 1.4 MB

Microsoft Balanced Data Distributor For SQL Server 2012 Tags


Microsoft Balanced Data Distributor For SQL Server 2012 Description

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.


Microsoft Balanced Data Distributor For SQL Server 2012 Related Software