SSIS:Personator:Output Filter: Difference between revisions
Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..." |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{SSISPersonatorNav | |||
|PersonatorTabsCollapse= | |||
{ | }} | ||
{ | |||
| | |||
| Line 56: | Line 12: | ||
==Result Codes== | ==Result Codes== | ||
The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box. | The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box. | ||
*[[Returned Result Codes:Enterprise Solutions#SSIS|Returned Result Codes]] | *[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]] | ||
| Line 75: | Line 31: | ||
:#'''Move Address Detected''' - [AS12] | :#'''Move Address Detected''' - [AS12] | ||
;Custom Filter | ;Custom Filter Expression | ||
:Records matching the filter will be directed to the designated file. | :Records matching the filter will be directed to the designated file. | ||
:For more information, see Custom Output Filters below. | :For more information, see Custom Output Filters below. | ||
Latest revision as of 23:57, 9 November 2015
← SSIS:Data Quality Components
| Personator Navigation | |||||||
|---|---|---|---|---|---|---|---|
| Overview | |||||||
| Tutorial | |||||||
| |||||||
| |||||||
|
The Personator Component will output records in up to four streams. The Output Filter tab allows you to control which records go to which stream. Names and usage can be done in any manner. Filters are evaluated from the top down.
Result Codes
The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box.
Output Filter
Select a filter to determine which records will be directed to a particular output stream. A custom filter may be created based on individual need, each pin filters the records in a cascading effect, where the results code is compared against the first expression (Pin 1) and then compared against Pin 2, and so on.
- No Filter
- All records are written to a single output stream.
- Pre-built Filter
- The Component comes with several pre-built filters for common applications:
- Address and Name Verified - [VR01]
- Full Address and Full Name Verified - [VR01] AND NOT [VS02] AND NOT [VS12]
- Full Address and Full Company Verified - [VR07] AND NOT [VS02] AND NOT [VS22]
- Address, Name, and Phone Verified - ([VR01] AND [VR04]) OR ([VR02] AND [VR04])
- One or more components verified - [VR*]
- Appended one or more contact pieces - [DA*]
- Move Address Detected - [AS12]
- Custom Filter Expression
- Records matching the filter will be directed to the designated file.
- For more information, see Custom Output Filters below.
Custom Output Filters
Custom rules are an advanced subject. You should be comfortable with Boolean operations before using custom rules in a production environment.
For more information see Custom Output Filters.