Today’s post isn’t specifically about SQL Server Denali, but still a worthy addition to the 30 Days of SSIS series. The Balanced Data Distributor is a new data flow component created by the SQLCAT team, and available for download from Microsoft.com. Carla Sabotta and Debarchan Sarkar have put together a training video for it, which is now available on technet:
In this video about the new Balanced Data Distributor (BDD) transformation, you’ll learn how to increase the throughput of the package Data Flow transformations by paralleling the Data Flow buffers to multiple outputs. The BDD transformation is designed to take advantage of the concurrent processing capability of modern CPUs.