This project has moved. For the latest updates, please go here.

Previous Install DTS Backup 2000 Manual Install Install SSIS Raw File Reader Next

Install SSIS Dimension Merge SCD

FineBuild can install and configure the SSIS Dimension Merge SCD as part of the SQL Server install process.
If you do not want to include SSIS Dimension Merge SCD in your FineBuild install, then do not download it.

SSIS Dimension Merge SCD is produced by Todd McDermid et al. It was chosen to be included in FineBuild because it provides a major building block within SSIS for implementing the Kimball methodology.

SSIS Dimension Merge SCD home page http://dimensionmergescd.codeplex.com
SSIS Dimension Merge SCD download http://dimensionmergescd.codeplex.com
SSIS Dimension Merge SCD tutorial http://dimensionmergescd.codeplex.com/wikipage?title=v1.6%20Usage%20Instructions
SSIS Dimension Merge SCD video http://www.youtube.com/watch?v=pBBBNgxcqds
Commercially supported and more recent version of SSIS Dimension Merge SCD http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/Features.aspx

FineBuild SSIS Dimension Merge SCD Install

Automated silent installation of SSIS Dimension Merge SCD is performed by Process Id 4IC and is controlled by the parameters below:
Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupDimensionSCD FULL Yes Yes Yes Yes Yes
SetupDimensionSCD WORKSTATION Yes Yes Yes Yes Yes
SetupDimensionSCD CLIENT Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameter InstDimensionSCD can also be used.

FineBuild also uses the following parameters to help install SSIS Dimension Merge SCD:
Parameter SQL Version Default Value Description
DimensionSCDzip Any Dimension Merge SCD Setups.zip Name of SSIS Dimension Merge SCD install media
DimensionSCDX86msi SQL 2008 and above Dimension Merge SCD Setup 2008 x86.msi Name of SSIS Dimension Merge SCD install file for 32-bit servers
DimensionSCDX64msi SQL 2008 and above Dimension Merge SCD Setup 2008 x64.msi Name of SSIS Dimension Merge SCD install file for 64-bit servers
DimensionSCDX86msi SQL 2005 Dimension Merge SCD Setup 2005 x86.msi Name of SSIS Dimension Merge SCD install file for 32-bit servers
DimensionSCDX64msi SQL 2005 Dimension Merge SCD Setup 2005 x64.msi Name of SSIS Dimension Merge SCD install file for 64-bit servers

SSIS Dimension Merge SCD cannot be installed by FineBuild on a Windows Core operating system because it is supplied in zip file format.

The FineBuild install for SSIS Dimension Merge SCD includes the following:
  • Perform a SSIS Dimension Merge SCD install

Manual SSIS Dimension Merge SCD Install

The following steps show what you would have to do to install SSIS Dimension Merge SCD manually. FineBuild does all of this work for you automatically.

1) Navigate to the Additional Components folder and click on Dimension Merge SCD Setups.zip.
DimensionMergeSCD Explorer.png
2) Double-click on the relevant file:

For SQL 2005 32-bit Dimension Merge SCD Setup 2005 x86.msi
For SQL 2005 64 bit Dimension Merge SCD Setup 2005 x64.msi
For SQL 2008 or above 32-bit Dimension Merge SCD Setup 2008 x86.msi
For SQL 2008 or above 64 bit Dimension Merge SCD Setup 2008 x64.msi

DimensionMergeSCD Install Explorer.png
3) The Welcome window is displayed. Click Next to continue.
DimensionMergeSCD Welcome.png
4) The Confirm Installation window is displayed. Click Next to continue.
DimensionMergeSCD Confirm.png
5) The Installation Complete window is displayed. Click Close to exit.
DimensionMergeSCD Complete.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install DTS Backup 2000 Top Install SSIS Raw File Reader Next

Last edited Oct 31, 2014 at 5:13 PM by EdVassie, version 23