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 joshgallagher.info for the fix.