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?
2条答案
按热度按时间kjthegm61#
Step-by-Step solution
.msi
package with loggingMSI (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.
.msi
package using 7zip , and it contains two filesBDDDll32
andBDDDll64
TxBDD.dll
(from the installation log this is the original name of the DLL)Balanced Data Distributor
is shown.Side Note: After checking the Event Viewer >> Windows Log >> Application, i also found the Error message listed above
References
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.