Hush-Hush Wiki

{TOC}

Requesting and Installing a Trial Version

We have provided an easy request form for the trial version of the components on our product page. Simply fill in the form and click on the button. We will email you the trial of the latest release promptly. Currently, the trial version will last for a month, after which the component will state that the period has expired. Please note that trial version often times will have limited features and only serves to familiarize you with the component. The production version of the component will contain the complete functionality. To download the trial version, you will need to know the version of Visual Studio you are using for SSIS development.

Preparing the environment

Visual Studio 2008 is home to familiar BIDS.

Visual Studio 2010 and 2012, as of June, 2013 also can be used for SSIS development. You will need to download SSDT

It is available for download here or via web installer

Please, also check whether you have an appropriate version of gacutil for further component registration.

Examples:

VS 2008, framework version 3.5 : C:\Program Files\Microsoft Visual Studio 9.0\SDK\v3.5\Bin\gacutil.exe

VS2010, 2012, framework version 4: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\bin\NETFX 4.0 Tools\gacutil.exe

Downloading and Installing

Along with the link to the files, we will send you a manual describing the functionality of the components and how to use them. Please read the description of the necessary components. Select the component version you would like to try (2008 or 2012) and use the appropriate one for your application.

Save the component's DLL into a temporary folder.

Integrate them into the SSIS depository in the following fashion:

1. Copy

1.Copy

If your SQL Server/BIDS/SSDT installation is done by default, you will copy the component into C:\Program Files(x86)\Microsoft SQL Server\xxx\DTS\PipelineComponents (32 bit)

Here is the map for SSIS development environment version (xxx) you are using:

BIDS (Visual Studio 2008): C:\Program Files(x86)\Microsoft SQL Server\100\DTS\PipelineComponents

SSDT (Visaul Studio 2010 and 2012): C:\Program Files(x86)\Microsoft SQL Server\110\DTS\PipelineComponents

If you installed SQL server in a customized fashion, please check this registry key to verify your location ( use regedit): HKEYLOCALMACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\xxx\SSIS\Setup\DtsPath

1. Register

   2.Register to GAC

gacutil /iF myComponent.dll

1. Refresh

   3.Refresh the SSIS Toolbox

In BIDS, 2008:

Right-click the toolbox and then click Choose Items.

In the Choose Toolbox Items dialog box, click the SSIS Data Flow Items tab for a data flow component.

Click the check box next to your component, and then click OK.

In SSDT, 2010, 2012:

Get into the Data Flow tab.

Right CLick on the toolbox.

Refresh the Toolbox.

Using the component

Please, use the component as you would any other. The components add the column of string/text data types with the original data masked. Map it as you would any other column.

Components how-tos videos