DimUserLoad
 LKP Source ZipCode AK (Component)
  Properties
Property Value
Name LKP Source ZipCode AK
Description Looks up values in a reference dataset by using exact matching.
Up Stream Components
Down Stream Components
ID 19
Component Class ID {27648839-180F-45E6-838D-AFF53DF682D2}
Contact Info Lookup;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5
Identification String component "LKP Source ZipCode AK" (19)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 5
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
CacheType
0
ConnectionType
0
DefaultCodePage
1252
MaxMemoryUsage
25
MaxMemoryUsage64
25
NoMatchBehavior
1
NoMatchCachePercentage
0
ParameterMap
#327;
ReferenceMetadataXml
<referenceMetadata><referenceColumns><referenceColumn name="ZipCodeAK" dataType="DT_STR" length="5" precision="0" scale="0" codePage="1252"/><referenceColumn name="ZipCode" dataType="DT_STR" length="5" precision="0" scale="0" codePage="1252"/><referenceColumn name="CountyFIPS" dataType="DT_STR" length="5" precision="0" scale="0" codePage="1252"/><referenceColumn name="County" dataType="DT_STR" length="45" precision="0" scale="0" codePage="1252"/><referenceColumn name="City" dataType="DT_STR" length="35" precision="0" scale="0" codePage="1252"/><referenceColumn name="State" dataType="DT_STR" length="2" precision="0" scale="0" codePage="1252"/></referenceColumns></referenceMetadata>
SqlCommand
SELECT DISTINCT 
       ZipCode as ZipCodeAK
      ,ZipCode
      ,CountyFIPS
      ,County
      ,City
      ,State
FROM ZIPCodes
WHERE County <> ' ' and PrimaryRecord = 'P'
SqlCommandParam
select * from (SELECT DISTINCT ZipCode as ZipCodeAK ,ZipCode ,CountyFIPS ,County ,City ,State FROM ZIPCodes WHERE County <> ' ' and PrimaryRecord = 'P') [refTable] where [refTable].[ZipCodeAK] = ?
  Input Columns
Name ID LineageID
ZipCodeAK
329
327
  Output Columns
Name ID LineageID
ErrorCode
36
36
ErrorColumn
37
37
Powered by BI Documenter