DimPayableLoad
 OLE_DST Load SCD1 temp table for Payable (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 temp table for Payable
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7655
Component Class ID {5A0B62E8-D91D-49F5-94A5-7BE58DE508F0}
Contact Info OLE DB Destination;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4
Identification String component "OLE_DST Load SCD1 temp table for Payable" (7655)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 4
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
FastLoadKeepIdentity
False
FastLoadKeepNulls
False
FastLoadMaxInsertCommitSize
2147483647
FastLoadOptions
TABLOCK,CHECK_CONSTRAINTS
OpenRowset
[dbo].[Staged_dbo_DimPayable__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
FiscalYear
7705
7611
Origin
8056
7980
OriginCode
8055
7979
PayableAK
8052
7977
PayableDate
8063
7987
PayableNumber
8054
7978
PayableSK
8053
7976
PayableStatus
8062
7986
PayableStatusCode
8061
7985
PaymentDate
8064
7988
PaymentType
8060
7984
PaymentTypeCode
8059
7983
PaymentTypeNumber
8183
8167
PaymentXrefNbr
8065
7989
ReferenceNumber
8182
8166
ReferenceType
8058
7982
ReferenceTypeCode
8057
7981
  Output Columns
Name ID LineageID
ErrorCode
7670
7670
ErrorColumn
7671
7671
Powered by BI Documenter