SSIS:SmartMover:Advanced Configuration: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
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
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISSmartMoverNav
 
|AdvancedConfigCollapse=
{| 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" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:SmartMover:Advanced Configuration|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]]
|}
|}





Revision as of 00:36, 14 November 2015

← 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



Advanced Configuration is located in the SmartMover Component under File > Advanced Configuration.

Melissa Data Cloud

For Melissa Data Cloud processing, you need the License String number issued to you by your sales representative. The other settings on this part of the Advanced Configuration screen should not be changed unless you are specifically directed to do so by Melissa Data Technical Support.

After entering the License String, click the Show Details button at the bottom of this screen to verify that the License String was entered correctly.

The following items should only be altered if directed by Melissa Data's support staff.

Use Proxy
If your network uses a Proxy Server, check this box and enter the Proxy information below.
Proxy URL
If your network uses a Proxy Server, enter the Proxy URL information on this field in order for the SmartMover Component to communicate with the Melissa Data Cloud. The format is "URL:port".
User Name
The user name for your Proxy Server, if any.
Password
The password for your Proxy Server, if any.
Maximum Threads
Specify the number of simultaneous requests to be sent to the Melissa Data Cloud Services to run in parallel.
Maximum Transaction Size
Specify the number of records to be sent to the Melissa Data Cloud per request.
Request Timeout
Specify the number of seconds for the SmartMover Component to wait before timing out. Some requests may experience connection lag or timeouts due to network problems.
Number of Retries
Specify the number of times the SmartMover Component should re-send a request to the Melissa Data Cloud due to any exceptions.
Abort on Critical Error
Will abort the process, in event of critical errors related to the Component such as the Web service code WSE00; Unexpected Error-Please Retry.

Test Configuration (Cloud)

Either the version number or build number will assist Melissa Data Technical Support in determining if you have the latest software installed on your system.

SmartMover Component

Component Version
Displays the current SSIS component version.
Build Number
Displays the current development release build number of the SmartMover Component for SSIS. This is usually a three or four-character string.
License Expiration
Displays the date the license expires.

SmartMover Web Service

Service Response
Displays the Web Service response status with the number of retries and seconds to connect.
Version
This box displays the version number of the SmartMover Web Service.