Install SSIS Dimension Merge SCD

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

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 was originally produced by Todd McDermid et al, and a commercial version is now available. It was chosen to be included in FineBuild because it provides a major building block within SSIS for implementing the Kimball methodology.

Item	Location
SSIS Dimension Merge SCD home page	https://web.archive.org/web/20161205060149/http://dimensionmergescd.codeplex.com/
SSIS Dimension Merge SCD download	https://web.archive.org/web/20210213104811/https://codeplexarchive.blob.core.windows.net/archive/projects/DimensionMergeSCD/DimensionMergeSCD.zip
SSIS Dimension Merge SCD video	https://www.youtube.com/watch?v=pBBBNgxcqds
Commercially supported and more recent version of SSIS Dimension Merge SCD	https://www.sentryone.com/products/task-factory/modules

After downloading from the web archive site, the following additional steps are needed to make the install media available:

Browse the DimensionMergeSCD.zip file
Navigate to the DimensionMergeSCD.zip\releases\6 folder
Copy the 90bd4ff1-be7e-4f07-9873-a03970626aa1 file to the \Additional Components folder
Rename the 90bd4ff1-be7e-4f07-9873-a03970626aa1 file to Dimension Merge SCD Setups.zip

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:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2017	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2016	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2014	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2012	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2008R2	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2008	/SetupDimensionSCD:	Yes	Yes	Yes
SQL2005	/SetupDimensionSCD:	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

Top

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.

Navigate to the Additional Components folder

Click on Dimension Merge SCD Setups.zip

Double-click on the relevant file:

Platform	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