SSIS:SmartMover: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISSmartMoverNav}}
 
{| 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 mw-collapsed" 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]]
|}
|}




Line 50: Line 6:
==SmartMover Overview==
==SmartMover Overview==
*U.S./Canadian change of address processing to update addresses of people or businesses that have moved.
*U.S./Canadian change of address processing to update addresses of people or businesses that have moved.
*NCOA and CCOA Processing Requirements:
**If US and Canadian records exists: Minimum requirement is 100 US and 100 Canada records
**If US Only: Minimum requirement is 100 US records
**If CA Only: Minimum requirement is 100 CA records




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

Latest revision as of 19:54, 31 July 2018

← SSIS:Data Quality Components

SmartMover Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
SmartMover Tabs
Input Columns
Output Columns
Processing Options
Pass-Through Columns
Output Filter
Result Codes
Result Codes



SmartMover Overview

  • U.S./Canadian change of address processing to update addresses of people or businesses that have moved.
  • NCOA and CCOA Processing Requirements:
    • If US and Canadian records exists: Minimum requirement is 100 US and 100 Canada records
    • If US Only: Minimum requirement is 100 US records
    • If CA Only: Minimum requirement is 100 CA records