Comments (8)
That is not supposed to happen. The installer is supposed to detect where the installation of SQL Server has been done.
Can you please check the content of the following registry keys?
SOFTWARE\Microsoft\Microsoft SQL Server\140\SSIS\Setup\DTSPath Key (Default)
SOFTWARE\Microsoft\Microsoft SQL Server\140\DTS\Setup Key SQLPath
The installer checks these registry locations, and gets the path from them.
If neither exists, it defaults to [ProgramFiles64Folder]\Microsoft SQL Server\140\DTS, which appears to be what has happened.
from ssismhash.
Both keys's value is: D:\Program Files\Microsoft SQL Server\140\DTS\
from ssismhash.
Is it possible for you to uninstall the component (and delete the files you manually copied), and re-install it with logging turned on in the installer, and upload that installation log file?
eg. (change the log location as appropriate)
msiexec /i "MultipleHashInstallerx64.msi" /L*V "D:\log\MultipleHashInstall.log"
If you can't upload the entire file, I am interested in the section that starts:
Action 22:50:27: AppSearch. Searching for installed applications
and finishes with (the time will be different)
Action ended 22:50:28: AppSearch. Return value 1.
This is where it logs what it finds in the registry.
from ssismhash.
I can do that later today or this evening.
from ssismhash.
For what it's worth...but, this may be the designed behavior. I'll still upload the log info later..
My HKLM has these paths and keys. However, HKCU does not. For example, HKCU stopped at the following path, and there was no DTS version of that path.
\HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\140\SSIS
from ssismhash.
I have built a clean server with SQL 2017 only installed onto D:. This has shown a defect in the installer, as it incorrectly identifies that SQL 2017 is not present. But, it did correctly identify the installation locations., as shown in a custom install.
Could you please clarify what else is installed on your server?
Is SSDT's installed, or another edition of SQL Server?
from ssismhash.
I suspect that you may have run into a known installer issue:
Known Installer Issue
If you have relocated the installation location from C: to another drive, AND one or more of the following folders exists, then you MUST use a CUSTOM install, and change the installation locations to your relocated install.
C:\Program Files\Microsoft SQL Server\nnn\DTS
C:\Program Files (x86)\Microsoft SQL Server\nnn\DTS
The symptom of this is that Multiple Hash will not show up in SSDT's.
I am testing a fix for this.
from ssismhash.
I have just released a new installer that corrects the issue where SSIS folders exist on C:, but are not the correct installation locations..
Release v1.7.4.0
Please try this installer, and confirm that it corrects the issue you encountered.
from ssismhash.
Related Issues (20)
- Installer v1.7.2 and Visual Studio 2017 (15.5.5) /SSDT 15.1.61710.120 - Does not appear in SSIS Toolbox HOT 1
- Cannot selectively choose hash columns HOT 6
- Possibility for a CustomProperty to specify numOfThreads HOT 3
- Installation to Azure SSIS runtime HOT 7
- Packages fail to run on server HOT 3
- Extending the component HOT 1
- No Setup.exe file in the download SSISMHash.zip. How do I install? HOT 2
- Anyway to migrate from 2008 to 2017 ? HOT 2
- SQL Server 2019 Support HOT 4
- Installer not compatible error HOT 1
- MultiHash 64 not working on SQL Server 2019 HOT 1
- Incorrect version showing in About menu HOT 4
- v1.7.5.0 is unsigned HOT 1
- Support SQL Server 2022 HOT 3
- Sha2(512) Value different in ADF/Snowflake than in SSIS HOT 1
- SSDT 17.2 compatibility HOT 3
- Proper location for Install for SSDT 2015 HOT 4
- SQL 2016 SP1 Support HOT 2
- Installer issue v1.7.2 - Not showing up in 140>DTS HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ssismhash.