Admin at 00:37, 14 November 2015

2015-11-14T00:37:20Z

@@ 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: 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-22T23:19:41Z

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 Input Columns tab configures the fields that will be used for the Change-of-Address lookup of the SmartMover Component, as well as the input for name splitting and address parsing.

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

To identify a changed address, the following fields are required for each record:
#Either FirstName and LastName, FullName or Company
#Address
#Either City and State, and or ZIP

Existing field names are selected using the dropdown boxes.

==Input Name==
===Name Format===
;Full Name
:If this is an individual person's address and the entire name is stored as a single string, pass the contents of that field here.

:If the contact Name is already parsed, the Component can use information via the fields below.

===Parsed Components===
;Prefix
:This would be a title or honorific such as "Mr," "Miss," or "Dr."

;First Name
:This field accepts the given name for each record containing an individual address.

;Middle Name
:This field accepts an individual's middle name if one exists.

;Last Name
:This field accepts the family name for each record containing an individual address.

;Suffix
:This field accepts any part of the name that follows the family name, such as degrees ("MD" or "PhD") and generational indicators ("IV" or "Jr."), if one exists.

==Select Country==
;Default Country
:The country to use if the country field is blank in the input.

==Input Address==
;Company
:If the database records may be business type, include the company field here.

;Address
:Select the field in the input database that contains the first line of street address information. It may also contain secondary address information such as suite and private mailbox numbers.

;Address2
:Select the field in the input database that contains the second line of street address information, if any.

;City
:Select the field in the input database that contains the city information.

;State/Province
:Select the field in the input database that contains the state information.

;Zip/Postal Code
:Select the field in the input database that contains the postal code information.

;Suite
:Select the field in the input database that contains the Suite address information, if any.

;Private Mailbox
:Select the field in the input database that contains the Private Mailbox number, if any.

;Urbanization
:Select the field in the input database that contains the urbanization information, if any.

:Urbanization is used to break ties between similar addresses in Puerto Rico. The urbanization name tells the address checking logic in which "neighborhood" to look, if more than one likely address candidate is found.

:If just one address is found, the address checking logic can correct the address and return the urbanization name.

;Plus 4
:Select the field in the input database that contains the Plus 4 extension for US ZIP codes, if this information is stored separately.

;Country
:Select the field containing the country of the input data.

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

SSIS:SmartMover:Input Columns - Revision history

Admin at 00:37, 14 November 2015

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..."