I have done a Custom install of Multiple Hash, but it does not show up in the SSIS Tool box for Data Flows. Please help me resolve this issue. The specifics of my install and the actions I have taken are described below.
I installed SQL Server 2016 on a Windows 2012R2 64 bit server the same way I have for prior versions of SQL Server, where the Shared Feature directories are in C:\Program Files\Microsoft SQL Server and C:\Program Files (x86)\Microsoft SQL Server, but the Instance Root Directory is in D:\Program Files\MySQLinstanceName.
Then I installed the MultipleHashInstallerx64_20170713_V1.7.1.0.msi, also the same way I have for prior versions of Multiple Hash and SQL Server, choosing Custom Install and choosing C:\Program Files\Microsoft SQL Server\130\DTS and C:\Program Files (x86)\Microsoft SQL Server\130\DTS for the Install locations.
After the install, I can see the MultipleHash2016.dll file in the PipelineComponents folder in the install locations.
When I open up SSDT 2015, I do not see Multiple Hash in the SSIS Toolbox Data Flow options.
Where should I have installed the Multiple Hash items?
Will I need to uninstall Multiple Hash and re-install it, or can I just move or copy the .dll files to the appropriate location?
If I installed them in the appropriate locations, what do I need to do so that Multiple Hash appears in the SSIS Toolbox for Data Flows?
I tried also installing MultipleHashInstallerx32_20170713_V1.7.1.0.msi, and I tried rebooting after the installs, but neither of those actions fixed the problem.
I also tried activating the Multiple Hash component within SSDT, but could not find a way to do this.
Right-clicking on "Common" or on "Other Transforms" (there is no "Data Flow Transformations" in SSDT 2015) gives only the option to "Refresh Toolbox". I tried this, but Multiple Hash does not appear in the Toolbox. I tried to activate it in SSDT using the Tools > Choose Toolbox Items menu options, but there is no "SSIS Data Flow Items" tab, and I did not find Multiple Hash on any of the tabs that did display.