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.

Preparing the environment

Visual Studio 2008 is home to familiar BIDS.

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

Downloading and Installing

Along with theThe link to the files, we will send you awill lead you to the installation, the manual describing, and installation instructions.

Run the functionalityinstaller.

You ofare good to go.

In case the components anddid hownot torefresh 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 thein SSIS depository in the following fashion:

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

2.Register to GAC

gacutil /iF myComponent.dllToolbox.

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