Balanced Data Distributor

I’ve recently been looking at using the BDD component for SSIS 10.0.

When attempting to install the component the following error was received –

“The installation is not successful. Check the following prerequisites: 1. Either Integration Services or BIDS has to be installed. 2. The version of these components has to be either SQL Server 2008 SP2 (or future SPs) or SQL Server 2008 R2 (or future SPs)”

It seems that this error is only received if you’ve patched your R2 instance to SP1.  The workaround is to trick the installer into thinking that a lower patch level is installed.

Using regedit set the following keys under HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\ to these values –

  • DTS\Setup\SP = 0
  • DTS\Setup\Version = 10.50.1600.1
  • BIDS\Setup\SP = 0
  • BIDS\Setup\Version = 10.50.1600.1


Thanks to for the fix.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s