1

Closed

Multiple Hash 1.6.3.4 not working with VStudio 2012 and SQL Server 2012.

description

Multiple Hash 1.6.3.4 not working with VStudio 2012 and SQL Server 2012.

file attachments

Closed Jul 21, 2016 at 12:38 PM by kmartin
Closed, as this requires the manual creation of a folder on C:, which is NOT where SQL Server Data Tools is installed.

comments

kmartin wrote Jul 10, 2014 at 7:37 AM

Can you please provide some details on what is not working?

Does it appear in the SSIS Toolbox?
Are there error messages when you install?
Are there error messages if you place the component on the design surface?

It has been tested against a Windows 8.1 with SSDT BI VS2012 version.

Keith

wrote Aug 29, 2014 at 1:05 AM

reicher1 wrote Aug 29, 2014 at 1:05 AM

I'm a different user, but am adding to this already-started issue.

I have "successfully" installed the current version of Multiple Hash a number of times without error, but it never appears in the SSIS Toolbox (SQL Server Data Tools, SQL Server 2012, Visual Studio Shell 2010). Custom log from msiexec attached.

Thanks.

reicher1 wrote Aug 29, 2014 at 1:19 AM

Uninstalling 1.6.3.4 and installing the previous stable version, Multiple Hash 1.6.1.2, it shows up in the SSIS Toolbox.

kmartin wrote Aug 29, 2014 at 12:08 PM

Thanks for the detailed install file.

For some reason the installer has detected the installation location for the 32bit dll (which is used by Visual Studio) as follows:
AppSearch: Property: SSIS32_2012_PATH, Signature: SSIS32_2012_PATH_1
MSI (c) (68:40) [20:52:26:727]: Note: 1: 2262 2: Signature 3: -2147287038 
MSI (c) (68:40) [20:52:26:728]: PROPERTY CHANGE: Adding SSIS32_2012_PATH property. Its value is 'K:\Program Files (x86)\Microsoft SQL Server\110\DTS\'.
AppSearch: Property: SSIS32_2012_PATH, Signature: SSIS32_2012_PATH_2
MSI (c) (68:40) [20:52:26:731]: Note: 1: 2262 2: Signature 3: -2147287038 
AppSearch: Property: SSIS32_2012_PATH, Signature: SSIS32_2012_PATH_3
MSI (c) (68:40) [20:52:26:734]: Note: 1: 2262 2: Signature 3: -2147287038 
MSI (c) (68:40) [20:52:26:734]: PROPERTY CHANGE: Modifying SSIS32_2012_PATH property. Its current value is 'K:\Program Files (x86)\Microsoft SQL Server\110\DTS\'. Its new value: 'C:\Program Files (x86)\Microsoft SQL Server\110\DTS\'.
I'm guessing that the K: is where you have installed the SQL Components.
If that is the case, then the installer has gone wrong in the detection of the 32 bit version, which is used by SSIS Toolbox.
Can you please confirm this. (I'll be testing this scenario over the weekend).

Although this question is probably impossible to answer:
Was there a folder 'C:\Program Files (x86)\Microsoft SQL Server\110\DTS\' on your machine before the installation?

FYI:
This has been caused by my attempts to make the installer detect SSDT's only installations.

kmartin wrote Aug 31, 2014 at 12:11 PM

Tested Configuration:
Windows 8.1 desktop (Clean Install)
SQL 2012 SQL, SSDT (VS2010) and SSIS installed to K:, but otherwise default parameters.
No 'C:\Program Files (x86)\Microsoft SQL Server\110\DTS\' after installation. ** This is expected and correct in this scenario **

Install v1.6.3.4 (Typical).
Works correctly in SSDT.
Uninstall v1.6.3.4
Create 'C:\Program Files (x86)\Microsoft SQL Server\110\DTS\'
Install v1.6.3.4 (Typical).
Not available in SSDT.
SSISMHash installed (32 bit) in C:\Program Files (x86)\Microsoft SQL Server\110\DTS\
SSISMHash installed (64 bit) in K:\Program Files\Microsoft SQL Server\110\DTS\
Uninstall v1.6.3.4
Install v1.6.3.4 (Custom). - Correct from C: to K: for 32 bit install.
Works correctly in SSDT.


Workaround:
Install as a CUSTOM install, and change the target directories to K: (or where you have SSIS installed).

wrote Jul 21, 2016 at 12:38 PM