Admin at 00:37, 14 November 2015

2015-11-14T00:37:46Z

@@ 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-23T17:42:01Z

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 following fields set the necessary options to process a list of address records.

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

==Processing Options==
===Processing Type===
This setting controls the type of Processing that will be performed on the data.
;*Standard Processing
:Queries business, individual and family records. In other words, does not omit any move records from the query.

;*Business and Individual Moves
:Omits family records.

;*Business Moves Only
:Omits family and individual move records.

;*Individual Moves Only
:Omits business and family move records.

;*Residential Moves
:Omits business and return individual and family move records.

;Mailing Frequency
:This field accepts an integer value from 1 to 52. This is the number of times per year that the current mailing list is used for mailing. If you use it monthly, enter 12; for quarterly, use 4, etc.

;Months Requested
:This field accepts an integer value from 6 to 48. This is the number of months back that you want the Web service to search for a change of address.

==Summary Reports==
Check the box next to '''Summary Reports''' to enable their use.

;List Name
:This is the name that identifies the current list. It will be included in the reports that SmartMover returns after processing.

;Save NCOA Summary in File
:Specifying a file name will generate this report which will contain the PAF information you provided Melissa Data, identify the name of the processed list and summarize the Change-of-Address statistics.

;Save 3553 CASS Form in File
:Specifying a file name will generate this CASS Summary Report which returns all of the information from processing your list that would be required to fill out a CASS 3553 form.

;Append JobId to the Reports file name
:Check this option to append the Job ID to the Reports file name.

;(Advanced Options) Override default Job ID
:Check this option if you want to override your existing job ID.

;Use a Job ID to Retrieve past Reports
:If you want to retrieve previous reports, click on “Use a Job ID to retrieve past Reports.”

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

===Retrieve Reports===
;Job ID
:Specify the Job ID here.

;Save NCOA Summary in File
:Specify the file location to save the NCOA summary.

;Save 3553 CASS Form in File
:Specify the file location to save the 3553 CASS form.

;Append JobId to the Reports file name
:Check this option to append the Job ID to the Reports file name.

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

SSIS:SmartMover:Processing Options - 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..."