SSIS:Generalized Cleanser Tutorial
|Generalized Cleanser Navigation|
The following steps will guide you in the basic usage of Generalized Cleanser Component for SSIS.
In the Generalized Cleanser Component, navigate to File > Advanced Configuration.
Set up the Generalized Cleanser Advanced Configuration. See Advanced Configuration.
To add Generalized Cleanser Component to your project, drag the component onto the Data Flow screen. This will add the Generalized Cleanser Component into your workflow.
Select a data flow source to be your input data. Many formats can be used as sources:
- Excel Files
- Flat Files
- Access Input Data Sources
Connect this Data Source to the Generalized Cleanser Component by clicking on your Data Source and dragging to the Generalized Cleanser Component.
Double click the Generalized Cleanser Component to bring up the interface.
These are the columns of your records.
These are the rules you are creating to cleanse your data. The following rules are available for your use:
- Regular Expression Search Replace
- Text Search Replace
For more information, see Cleansing Details.
There are 3 triggers that you can use to determine whether or not a rule should be used for a record:
- Regular Expression
For more information, see Triggers.
Create rules that will enable you to use this rule for multiple source fields. Here you can create a name and description for this rule.
After you have created your new rule, you may select it in the “Operation Rule” field on the main page of the Generalized Cleanser Component.
It is highly recommended to create a new rule for each source field.
You can use our expression builder to build your own expressions and save them for future use as a Pre-Built Expression. You can also use this to test your custom built expression to ensure correct syntax.
Select the desired output destination type and click and drag from the Generalized Cleanser Component to the Destination Output. Once they are connected, configure your output.
Click File and select Save All to save everything in your project.
Now the project is ready to run.