SSIS:SmartMover:Advanced Configuration - Revision history

Admin at 21:06, 19 December 2016

2016-12-19T21:06:36Z

← Older revision		Revision as of 21:06, 19 December 2016
Line 9:		Line 9:

	==Melissa Data Cloud==		==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.		For Melissa Data Cloud processing, you need the License Key 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.		After entering the License Key, click the Show Details button at the bottom of this screen to verify that the License Key was entered correctly.

	[[File:SSIS_SM_Advanced_Cloud.png\|link=]]		[[File:SSIS_SM_Advanced_Cloud.png\|link=]]
Line 57:		Line 57:

	;License Expiration		;License Expiration
	:Displays the date the ~~license~~ expires.		:Displays the date the License Key expires.

	====SmartMover Web Service====		====SmartMover Web Service====

Admin at 00:36, 14 November 2015

2015-11-14T00:36:47Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; 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;"
+}}

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-22T19:23:15Z

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" 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]]
|}
|}

{{CustomTOC}}

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.

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

<span style="color:red;">'''The following items should only be altered if directed by Melissa Data's support staff.'''</span>

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

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

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

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