Search code examples
sql-servervisual-studio-2013ssissql-server-data-toolsbalanced-data-distributor

Balanced Data Distributor Installation Error

I am working with SQL Server 2014 SP3 x64 and i have installed the cumulative update 1. I have installed Visual Studio 2013 Professional and SQL Server Data Tools - Business Intelligence for Visual Studio and it works perfectly (I can design an run SSIS packages without any issue).

I downloaded SSIS Balanced Data Distributor for the following Microsoft download Links:

When I run the installation packages (both x64 and x86 - from both links), I get the following Error:

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

I tried to run the .msi as administrator from cmd with no luck. (I am a member of administrators)

I also checked the following link Problem in Installing the Balanced data Distributor for SSIS 2012 which is about the same error, but i think this is a different situtation.

Any Suggestion?

Solution

  • Step-by-Step solution

    1. First I executed the .msi package with logging

      msiexec /i BalancedDistributor-amd64.msi /l*v "install.log"

    2. I checked the log file untill i found the following error:

    MSI (s) (5C:EC) [12:32:01:306]: Product: Microsoft Balanced Data Distributor for SQL Server 2014 (x64) -- 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 RegisterBDD32, location: C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents\, command: regsvr32.exe /s "C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents\TxBDD.dll"

    Which means that the package encountered an error during the Dll registration.

    1. I extracted the .msi package using 7zip , and it contains two files BDDDll32 and BDDDll64
    2. I renamed these files to TxBDD.dll (from the installation log this is the original name of the DLL)

    3. I copy the files to the following directories:

      32-bit >> C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents
64-bit >> C:\Program Files\Microsoft SQL Server\120\DTS\PipelineComponents

    4. After that i started cmd as Administrator and i executed the following commands:

      regsvr32.exe /s "C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents\TxBDD.dll
regsvr32.exe /s "C:\Program Files\Microsoft SQL Server\120\DTS\PipelineComponents\TxBDD.dll

    5. After that i started Visual Studio and on SSIS toolbox i click Refresh Items, and the Balanced Data Distributor is shown.

    Side Note: After checking the Event Viewer >> Windows Log >> Application, i also found the Error message listed above

    References