Installing the Kimball Method Slowly Changing Dimension Component

See Upgrading Instructions in order to upgrade from prior versions.
The installation instructions are the same for installing this component in Integration Services 2005 or 2008. Please note that you must run the appropriate installer for the version of SQL Server Integration Services that you have installed on your system, and that packages created for Integration Services 2005 will not run on SSIS 2008 and vice versa.

Development Machine Instructions

Follow the instructions below to install and use the component on any machine you intend to develop Integration Services packages on.
  1. Extract the appropriate installer (2005 or 2008, x86 or x64) from the ZIP file you downloaded from the releases page.
  2. Double-click on the MSI to launch it, and complete the installation.
  3. Open BIDS (Business Intelligence Development Studio, AKA Visual Studio).
  4. Open or create an Integration Services project.
  5. Add a Data Flow component to your package and double-click on it.
  6. Right-click on the Toolbox and select “Choose Items...”
  7. Select the “Data Flow Components” tab, and place a checkmark next to “Kimball Method SCD”.

Server Machine Instructions

Follow the instructions below to install the component on any machine you intend to run packages containing the component.
  1. Extract the appropriate installer (2005 or 2008, x86 or x64) from the ZIP file you downloaded from the releases page.
  2. Double-click on the MSI to launch it, and complete the installation.

Installation Troubleshooting

If you have any difficulties with the above instructions, you can:
  1. Continue reading to understand what the installer does.
  2. View the Troubleshooting FAQ.
  3. Post a message in the Discussions to ask for help.

Installer Details

The installer will proceed to place two .Net DLLs in the GAC (Global Assembly Cache) – you will require Administrator access on Vista/Win7 to permit this, and UAC will probably pop up to confirm you trust the installer’s actions. It will also place a copy of the DLLs in the default location for SQL Server Integration Services Data Flow Components:
  • For SSIS 2005 – <ProgramFilesFolder>\Microsoft SQL Server\90\DTS\PipelineComponents
  • For SSIS 2008 – <ProgramFilesFolder>\Microsoft SQL Server\100\DTS\PipelineComponents

Uninstalling the Component

  1. Use the Add/Remove Programs function in Control Panel to remove the component.
  2. Open an Integration Services project in BIDS.
  3. Right-click on the Kimball Method SCD icon in the Toolbox, and select Delete.

Manual Installation Instructions

If using the included installer isn't something you want to do, you can install the component manually.
  1. Download and build the source code.
  2. Install KimballMethodSCDxxx.DLL and SSISComponentUtilities.DLL into the GAC. You will need GACUtil in order to accomplish this - it is not included in standard Windows. You must install a .Net SDK or Windows Platform SDK in order to get this utility.
  3. Copy the KimballMethodSCDxxx.DLL to the PipelineComponents folder identified above for your version of SQL Server.
If you alter the source code, you must re-GAC and re-copy all of the binaries to the above locations. If you do not, then you will experience inconsistent behaviour with the component!

Last edited Jan 24, 2010 at 8:45 PM by toddmcdermid, version 5

Comments

MikeHoney Apr 11, 2011 at 1:19 AM 
Using SQL Server 2008 R2, step 7 under Development Machine Instructions is slightly different. You need to choose the "SSIS Data Flow Items" tab.

MikeHoney Apr 11, 2011 at 1:17 AM 
This page appears to be out-of-date for release 1.6 - the component name change from v1.5 has affected several specific object names e.g. the DLL name and component name. Generally if you replace "Kimball Method" with "Dimension Merge" you can figure it out.