DimUserLoad
 OLE_SRC ZipCountySK List From Fact Tables (Component)
  Properties
Property Value
Name OLE_SRC ZipCountySK List From Fact Tables
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 ZipCountySK List From Fact Tables" (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 
    cast('FactPayableAmounts' AS VARCHAR(50)) AS FactTable,
    fact.ZipCountySK
FROM dbo.FactPayableAmounts fact
WHERE ZipCountySK > -1
UNION
SELECT DISTINCT 
    cast('FactPurchaseOrderAmounts' AS VARCHAR(50)) AS FactTable,
    fact.ZipCountySK
FROM dbo.FactPurchaseOrderAmounts fact
WHERE ZipCountySK > -1
SqlCommandVariable
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
ErrorCode
13
13
ErrorColumn
14
14
FactTable
85
85
ZipCountySK
293
293
FactTable
84
84
ZipCountySK
292
292
Powered by BI Documenter