SQL Server Balanced Data Distributor Installation Error

a1o7rhls 于 2023-03-28 发布在其他

关注(0)|答案(2)|浏览(272)

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?

sql-server

来源：https://stackoverflow.com/questions/54309400/balanced-data-distributor-installation-error

2条答案

按热度按时间

kjthegm61#

Step-by-Step solution

First I executed the .msi package with logging

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

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.

I extracted the .msi package using 7zip , and it contains two files BDDDll32 and BDDDll64
I renamed these files to TxBDD.dll(from the installation log this is the original name of the DLL)
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

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

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

赞(0）回复(0）举报 2023-03-28

nhaq1z212#

I also ran into the above error installing BDD recently on Windows 2012R2 64-bit with SQL 2014 SP3.

I tried the above solutions and still received the error. Found that when SQL2014 was installed the Shared Components Management Tools -Basic and Management Tools -Complete were not installed.

After adding these Shared Components to the SQL 2014 install, BDD installed successfully.

The Management Tools installs these programs which are apparently needed for BDD:

.Net 4.0 Multi Targeting Pack

Visual Studio 2010 Shell

Hope this helps anyone else struggling with this.

赞(0）回复(0）举报 2023-03-28

我来回答

SQL Server Balanced Data Distributor Installation Error

2条答案

Step-by-Step solution

References

相关问题

热门标签

最新问答