DimPayeeLoad
 OLE_SRC Verification Temp Payee table from Vendor in Staging (Component)
  Properties
Property Value
Name OLE_SRC Verification Temp Payee table from Vendor in Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 2569
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 Payee table from Vendor in Staging" (2569)
Is Default Locale False
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 7
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
exec usp_DimOrgUnit_Select
SqlCommandVariable
User::GetVendorMods
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
Country
2614
2614
ErrorCode
2615
2615
ErrorColumn
2616
2616
IsMinority
2610
2610
PayeeAK
2604
2604
PayeeId
2605
2605
PayeeName
2609
2609
PayeeNameConsolidated
2621
2621
PayeeSequence
2606
2606
PayeeType
2608
2608
PayeeTypeCode
2607
2607
State
2612
2612
StateCode
2611
2611
ZipCode
2613
2613
Country
2591
2591
IsMinority
2587
2587
PayeeAK
2581
2581
PayeeId
2582
2582
PayeeName
2586
2586
PayeeNameConsolidated
2620
2620
PayeeSequence
2583
2583
PayeeType
2585
2585
PayeeTypeCode
2584
2584
State
2589
2589
StateCode
2588
2588
ZipCode
2590
2590
Powered by BI Documenter