SSIS:Global Verify:Email - Revision history

Admin at 19:17, 1 June 2020

2020-06-01T19:17:26Z

← Older revision		Revision as of 19:17, 1 June 2020
Line 77:		Line 77:
	;Privacy Flag		;Privacy Flag
	:The top level domains or countries that may be sensitive to privacy laws. Returns <code>Y</code> for yes and <code>N</code> for no.		:The top level domains or countries that may be sensitive to privacy laws. Returns <code>Y</code> for yes and <code>N</code> for no.

			;MX Server
			:Returns which MX Server was used to validate the email address. Only available in Premium Mode.

Admin at 22:57, 5 June 2019

2019-06-05T22:57:45Z

@@ Line 29: / Line 29: @@
 ;Top Level Domain Description
 :The name for the top level domain description output column.
@@ Line 43: / Line 91: @@
 ;Days Since Last Verified
-''Premium Mode Only''
+:''Premium Mode Only''
-You can choose how fresh you want your data. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.
+;Domain Information ON/OFF
 [[Category:SSIS]]
 [[Category:SSIS Global Verify]]

Admin at 20:51, 13 August 2015

2015-08-13T20:51:26Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; SSIS Reference]]
+{{SSISGlobalVerifyNav
+|GlobalVerifyCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}
 {{CustomTOC}}

Admin at 20:59, 10 June 2015

2015-06-10T20:59:27Z

← Older revision		Revision as of 20:59, 10 June 2015
Line 85:		Line 85:
	Note: The 'Off' and 'Mixed' options have been deprecated.		Note: The 'Off' and 'Mixed' options have been deprecated.

	==~~Day~~ Since Last Verified==		==Advanced Email Options==
			;Days Since Last Verified

	''Premium Mode Only''		''Premium Mode Only''
	You can choose how fresh you want your data. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.
			You can choose how fresh you want your data. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.


	[[Category:SSIS]]		[[Category:SSIS]]
	[[Category:SSIS Global Verify]]		[[Category:SSIS Global Verify]]

Admin at 20:09, 10 June 2015

2015-06-10T20:09:00Z

← Older revision		Revision as of 20:09, 10 June 2015
Line 77:		Line 77:

	==Mailbox Verification Options==		==Mailbox Verification Options==
	~~;Off (Depreciated)~~		;Express
	~~:No checking on the mailbox is done.~~

	~~;Mixed (Depreciated)~~
	~~:Check the Email Address against the Web Service Email Reference Data. If the Email is not found in the data, run it through real-time Email Verification.~~

	;Express ~~(Also known as Fast)~~
	:Check the Email Address against the Web Service Email Reference Data.		:Check the Email Address against the Web Service Email Reference Data.

	;Premium ~~(Also known as Realtime)~~		;Premium
	:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.		:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.

	*;Day Since Last Verified (Premium Mode Only)		Note: The 'Off' and 'Mixed' options have been deprecated.
	**:You can ~~set~~ how fresh ~~the data~~ you want. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.
			==Day Since Last Verified==
			''Premium Mode Only''
			You can choose how fresh you want your data. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.

	[[Category:SSIS]]		[[Category:SSIS]]
	[[Category:SSIS Global Verify]]		[[Category:SSIS Global Verify]]

Oscar: /* Mailbox Verification Options */

2015-06-10T17:31:19Z

Mailbox Verification Options

← Older revision		Revision as of 17:31, 10 June 2015
Line 89:		Line 89:
	:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.		:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.

	;Day Since Last Verified (Premium Mode Only)		*;Day Since Last Verified (Premium Mode Only)
	:You can set how fresh the data you want. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.		**:You can set how fresh the data you want. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.

	[[Category:SSIS]]		[[Category:SSIS]]
	[[Category:SSIS Global Verify]]		[[Category:SSIS Global Verify]]

Oscar: /* Mailbox Verification Options */

2015-06-10T17:31:05Z

Mailbox Verification Options

← Older revision		Revision as of 17:31, 10 June 2015
Line 89:		Line 89:
	:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.		:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.

			;Day Since Last Verified (Premium Mode Only)
			:You can set how fresh the data you want. By setting a higher value, you will receive faster responses but the data will not be as fresh. You can set this value from 3 to 365 days.

	[[Category:SSIS]]		[[Category:SSIS]]
	[[Category:SSIS Global Verify]]		[[Category:SSIS Global Verify]]

Oscar: /* Mailbox Verification Options */

2015-06-10T17:29:28Z

Mailbox Verification Options

← Older revision		Revision as of 17:29, 10 June 2015
Line 77:		Line 77:

	==Mailbox Verification Options==		==Mailbox Verification Options==
	;Off		;Off (Depreciated)
	:No checking on the mailbox is done.		:No checking on the mailbox is done.

	;Mixed		;Mixed (Depreciated)
	:Check the Email Address against the Web Service Email Reference Data. If the Email is not found in the data, run it through real-time Email Verification.		:Check the Email Address against the Web Service Email Reference Data. If the Email is not found in the data, run it through real-time Email Verification.

	;Fast		;Express (Also known as Fast)
	:Check the Email Address against the Web Service Email Reference Data.		:Check the Email Address against the Web Service Email Reference Data.

	;Realtime		;Premium (Also known as Realtime)
	:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.		:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.

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-17T21:28:46Z

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;"|'''Global Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Global Verify|Overview]]
|-
|[[SSIS:Global Verify Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Global Verify:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Global Verify Tabs
|-
|[[SSIS:Global Verify:Name|Name]]
|-
|[[SSIS:Global Verify:Address|Address]]
|-
|[[SSIS:Global Verify:Phone|Phone]]
|-
|[[SSIS:Global Verify:Email|Email]]
|-
|[[SSIS:Global Verify:Pass-Through Columns|Pass-Through Columns]]
|-
|[[SSIS:Global Verify:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

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

Verify the domain of an email address as well as correct syntax, typos, and update older domain names.

==Input Columns==
;Email Address
:Select the field containing the input email address.

==Output Columns==
;Email Address
:The name for the email address output column.

;Mail Box Name
:The name for the mail box output column.

;Domain Name
:The name for the domain output column.

;Top Level Domain
:The name for the top level domain output column.

;Top Level Domain Description
:The name for the top level domain description output column.

==Mailbox Verification Options==
;Off
:No checking on the mailbox is done.

;Mixed
:Check the Email Address against the Web Service Email Reference Data. If the Email is not found in the data, run it through real-time Email Verification.

;Fast
:Check the Email Address against the Web Service Email Reference Data.

;Realtime
:Check the Email Address against the Web Service Email Reference Data. If the Email has not been verified within the last 3 days in the Web Service Reference Data, run the Email through real-time Email Verification.

[[Category:SSIS]]
[[Category:SSIS Global Verify]]