SSIS:MatchUp:Lookup Pass-Through

From Melissa Data Wiki
Revision as of 23:54, 1 December 2014 by Admin (talk | contribs) (Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← SSIS Reference

MatchUp Navigation
Overview
Tutorial
Advanced Configuration
On-Premise
MatchUp Tabs
Matchcode
Field Mapping
Options
Golden Record
Survivorship/Pass-Through
Lookup Pass-Through Columns
Output Filter
Matchcode Editor
Matchcode List
Component List
Component Properties
Algorithms
Matchcodes Overview
Component Combinations
Blank Field Mapping
Mapping
Optimization
Swap Matching
Result Codes
Returned Result Codes
Result Codes


This tab is HIDDEN When there is only a single upstream source connected to the MatchUp Component.

This shows a list of the fields in your input Lookup stream. When there is only a single input source connected, this tab will not be visible.



Pass Through
Check this box if you would like the contents of the checked field name to be passed to the Lookup output stream without modification, in addition to the Output Columns specified in Options.
Column Name
The column names from the original input table.
Current Usage
Where the field is currently being used as input.
Data Type
The data type of each column.
Length
Maximum number of bytes returned.
Precision
Maximum number of digits.
Scale
Maximum number of digits to the right of the decimal point.