Admin at 20:49, 13 August 2015

2015-08-13T20:49:13Z

← Older revision		Revision as of 20:49, 13 August 2015
Line 1:		Line 1:
	~~[[SSIS:Reference\|← SSIS Reference]]~~		{{SSISGlobalVerifyNav}}

	{~~\| 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 mw-collapsed" 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}}		{{CustomTOC}}

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-17T19:28:56Z

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 mw-collapsed" 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}}

The following steps will guide you in the basic usage of Global Verify for SSIS.

==Advanced Configuration==
In the Global Verify Component, navigate to File > Advanced Configuration.

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

Set up the Global Verify Advanced Configuration. See [[SSIS:Global Verify:Advanced Configuration|Advanced Configuration]].

==Add Component==
To add the Global Verify Component to your project, drag the component onto the Data Flow screen. This will snap the Global Verify Component into your workflow space.

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

==Connect Input==
Select a data flow source to be your input data. Many formats can be used as Sources, including Excel files, flat files or Access Input data sources. Connect this data source to the Global Verify Component by dragging the arrow from your data flow source to the Global Verify Component.

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

==Configure Component==
Double click the Global Verify Component to bring up the interface.

===Name Tab===
Map the input name fields.

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

===Address Tab===
Map the address input fields and continue to the next page of the Address tab.

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

Map the address output fields. If you want additional address output fields, continue to the next page of the Address tab.

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

Map the additional address output fields.

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

===Phone Tab===
If you have an input phone field, specify it and the country.

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

===Email Tab===
If you have an input email address field, specify it here and choose your email verify options.

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

===Pass-Through Columns Tab===
You may choose which fields to pass through to the data file and which fields to filter out.

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

===Output Filter Tab===
You can specify the filter from the drop down or you can also create your own custom filter.

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

==Connect Output==
Add data destinations for downstream output. Connect the respective output filter pin to the output destination.

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

==Save Settings==
Click File and select Save Selected Items to save the project

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

==Run Project==
Now, the project is ready to run.

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

SSIS:Global Verify Tutorial - Revision history

Admin at 20:49, 13 August 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..."