DimPayableLoad
 OLE_DST Load New Temp table for Payable (Component)
  Properties
Property Value
Name OLE_DST Load New Temp table for Payable
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7672
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 New Temp table for Payable" (7672)
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__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
FiscalYear
7730
7583
Origin
8083
7950
OriginCode
8082
7949
PayableAK
8080
7947
PayableDate
8090
7957
PayableNumber
8081
7948
PayableStatus
8089
7956
PayableStatusCode
8088
7955
PaymentDate
8091
7958
PaymentType
8087
7954
PaymentTypeCode
8086
7953
PaymentTypeNumber
8187
8161
PaymentXrefNbr
8092
7959
ReferenceNumber
8186
8160
ReferenceType
8085
7952
ReferenceTypeCode
8084
7951
RowEndDate
7727
7579
RowIsCurrent
7725
7577
RowStartDate
7726
7578
  Output Columns
Name ID LineageID
ErrorCode
7687
7687
ErrorColumn
7688
7688
Powered by BI Documenter