DimUserLoad
 OLE_SRC DimZipCounty SK List (Component)
  Properties
Property Value
Name OLE_SRC DimZipCounty SK List
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 DimZipCounty SK List" (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 ZipCountySK
      ,ZipCodeAK
  FROM DimZipCounty
WHERE ZipCountySK > -1;
SqlCommandVariable
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
ErrorCode
13
13
ErrorColumn
14
14
ZipCodeAK
328
328
ZipCountySK
325
325
ZipCodeAK
327
327
ZipCountySK
324
324
Powered by BI Documenter