Tips for Binary Install

Mar 24, 2009 at 9:22 PM

All,
I was stuck unable to get the 2005 1.4 version component installed using the msi installer.
I have successfully used the Kimball_SCD_v1.4 2009-03-09_Setup_2008.msi to get the 2008 version installed.
I also had added to BIDS 2008 Data Flow Transformation toolbox.
No such luck with 2005.
I have summarized the (painfull) steps taken so others may benefit from avoiding my mistakes.

To summarize what worked:
1. Did not use the Kimball_SCD_v1.4 2009-03-09_Setup_2005.msi
    This msi did not work for getting the componnts into the right place to add to BIDS 2005
2. Copied files from .zip to  C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\
3. Opened the Command Line Utiltiy cmd.exe using Run As... Administrator
4. Changed directory to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents
5. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\SSISComponentUtilities.dll"
6. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\KimballMethodSCD.dll"
7. Added to BIDS toolbox in Data Flow Transformations section
  a. Right clicked on section of tookbox and selected Choose Items...
 b. On Choose Toolbox Items dialog, selected the SSIS Data Flow Items tab
 c. On SSIS Data Flow Items tab, selected the Kimball Method Slowly Changing Dimension component

PC:
WIndowsXP SP3
SQL Server 2005 Dev Edition
SQL Server 2008 Dev Edition
.NET Framework Versions:
v1.0.3705
v1.1.4322
v2.0.50727
v3.0
v3.5 (including SP1)

 1. Ran Kimball_SCD_v1.4 2009-03-09_Setup_2005.msi
 2. Attempted to add to BIDS toolbox in Data Flow Transformations section
  a. Right clicked on section of tookbox and selected Choose items...
  b. On Choose Toolbox Items dialog, selected the SSIS Data Flow Items tab
  c. No Kimball SCD componet in listing
 3. Browsed C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents folder
  a. located KimballMethodSCD.dll
  b. missing SSISComponentUtilities.dll
 4. Copied SSISComponentUtilities.dll to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents folder
 5. Opened the Command Line Utility cmd.exe
 6. Changed directory to C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
 7. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\SSISComponentUtilities.dll"
 8. Received error: "Failure adding assembly to the cache: Unknown Error"
 9. Opened the Command Line Utiltiy cmd.exe using Run As... Administrator
10. Changed directory to C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322
11. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\SSISComponentUtilities.dll"
12. Received error: "Failure adding assembly to the cache: Unknown Error"
13. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\KimballMethodSCD.dll"
14. Received error: "Failure adding assembly to the cache: Unknown Error"
15. Reran Kimball_SCD_v1.4 2009-03-09_Setup_2005.msi to Remove Componets
16. Browsed C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents folder
  a. missing KimballMethodSCD.dll
  b. found SSISComponentUtilities.dll
  c. deleted SSISComponentUtilities.dll
17. Opened the Command Line Utiltiy cmd.exe using Run As... Administrator
18. Changed directory to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents
19. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\SSISComponentUtilities.dll"
20. Success:
 "Microsoft <R> .NET Global Assembly Cache Utility. Version 3.5.30729.1
  Copyright...
  Assembly successfully added to the cache"
21. Ran command gacutil /i "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\KimballMethodSCD.dll"
22. Success:
 "Microsoft <R> .NET Global Assembly Cache Utility. Version 3.5.30729.1
  Copyright...
  Assembly successfully added to the cache"

Coordinator
Mar 25, 2009 at 5:35 PM
The above works only because you uninstalled 2005, which actually uninstalled part of the 2008 component... so it really boils down to the issue you added about supporting side-by-side installs: http://kimballscd.codeplex.com/WorkItem/View.aspx?WorkItemId=2389

Thanks for bringing that to my attention.