SSIS:SmartMover:Output Filter - Revision history

Admin at 00:38, 14 November 2015

2015-11-14T00:38:12Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; SSIS Reference]]
+{{SSISSmartMoverNav
+|SmartMoverTabsCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}

Admin at 23:38, 18 June 2015

2015-06-18T23:38:28Z

← Older revision		Revision as of 23:38, 18 June 2015
Line 54:		Line 54:
	==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#Data Quality ~~Comnponents~~ for SSIS\|Returned Result Codes]]		*[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS\|Returned Result Codes]]

Admin at 17:51, 23 October 2014

2014-10-23T17:51:36Z

← Older revision		Revision as of 17:51, 23 October 2014
Line 44:		Line 44:
	\|}		\|}
	\|}		\|}


	{{CustomTOC}}		{{CustomTOC}}

Admin: Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

2014-10-23T17:51:29Z

Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

New page

[[SSIS:Reference|← SSIS Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''SmartMover Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:SmartMover|Overview]]
|-
|[[SSIS:SmartMover Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:SmartMover:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:SmartMover:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|SmartMover Tabs
|-
|[[SSIS:SmartMover:Input Columns|Input Columns]]
|-
|[[SSIS:SmartMover:Output Columns|Output Columns]]
|-
|[[SSIS:SmartMover:Processing Options|Processing Options]]
|-
|[[SSIS:SmartMover:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:SmartMover:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:SmartMover:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

The SmartMover 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.

[[File:SSIS_SM_OutputFilter.png|link=]]

==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.
*[[Returned Result Codes:Enterprise Solutions#Data Quality Comnponents for SSIS|Returned Result Codes]]

==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:
:#'''Moved Addresses''' - [CS01] - The record is determined to have a Change of Address according to the supplied name and address.
:#'''Valid Address or Changed Address''' - [CS01] OR [CS02] - The record is determined to have at a minimum, a verified address and possibly a Change of Address according to the supplied name and address.

;Custom Filter Expression
:Records matching the filter will be directed to the designated file.
:For more information, see Custom Output Filters below.

==[[SSIS:Custom Output Filters|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 [[SSIS:Custom Output Filters|Custom Output Filters]].

[[Category:SSIS]]
[[Category:SSIS SmartMover]]