DimUserLoad
 OLE_SRC Verification Temp table from ZIPCodes Staging (Component)
  Properties
Property Value
Name OLE_SRC Verification Temp table from ZIPCodes Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 1
Component Class ID {BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String component "OLE_SRC Verification Temp table from ZIPCodes Staging" (1)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 7
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
2
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
SELECT DISTINCT 
       ZipCode as ZipCodeAK
      ,ZipCode
      ,CountyFIPS
      ,County
      ,City
      ,State
FROM ZIPCodes
WHERE County <> ' ' and PrimaryRecord = 'P'
ORDER BY ZipCodeAK, County
SqlCommandVariable
User::GetStudentTermMods
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
City
2234
2234
County
2231
2231
CountyFIPS
2228
2228
ErrorCode
13
13
ErrorColumn
14
14
State
2237
2237
ZipCode
2225
2225
ZipCodeAK
2222
2222
City
2233
2233
County
2230
2230
CountyFIPS
2227
2227
State
2236
2236
ZipCode
2224
2224
ZipCodeAK
2221
2221
Powered by BI Documenter