Installing the Dimension Merge 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 Task 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 “Dimension Merge Slowly Changing Dimension”.

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
  • For SSIS 2005 and 2008, if you run the 64-bit installer on a 64-bit system, the DLLs will be placed in BOTH 32-bit and 64-bit Program Files folders.

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 Dimension Merge Slowly Changing Dimension item in the Toolbox, and select Delete.

Manual Installation Instructions

If using the included installer isn't something you want to do, or it's not working for you, the component can be installed manually.
  1. Download and build the source code, or copy the DLLs from the failed installation.
  2. Install DimensionMergeSCDxxx.DLL and SSISComponentUtilitiesxxx.DLL into the GAC (where xxx is "100" or "90" depending on your SSIS version). You will need GACUtil in order to accomplish this - it is not included in standard Windows installations. You must install a .Net SDK or Windows Platform SDK in order to get this utility.
  3. Copy the DimensionMergeSCDxxx.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 Apr 13, 2011 at 6:53 PM by toddmcdermid, version 1

Comments

No comments yet.