"The installation is not successful. Check the following prerequisites: 1. Either Integration Services or SSDT has to be installed. 2. The version of these components has to be SQL Server 2012 (or future SPs)."
(I had both installed naturaly)
After some searching I discoverred, you cannot install the package on machine where is not SQL server 2012 installed.
Huh? As developer I dont have installed SQL server, why should I? I want only create SSIS packages...
Ok, thanks Microsoft for making developing easy again.
Fortunately, there is a workaround, you have to convice the installer then SQL Server is installed on your machine by adding some keys to register.
- Run > regedit
- Add following keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\DTS\Setup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\BIDS\Setup
- To the both keys add a values:
SP = 0
Version = 11.0.2100.60
But there was another problem with installation:
"Problem with this windows installer package. A program run as part of the installation did not finish as expected. Contact your support personnel or package vendor"
In windows log I found:
"Error 1722. There is a problem with this Windows Installer package. A program run as part of the installation did not finish as expected. Contact your support personnel or package vendor. Action RegisterBDD64, location: C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\, command: regsvr32.exe /s "C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxBDD.dll"
- Download 32bit version, not 64.
Problem solved, all installed.
(Product: Microsoft Balanced Data Distributor for SQL Server 2012 (x86) -- Installation completed successfully.)