DimPurchaseOrderLoad
 OLE_DEST Load Verification table PurchaseOrder Operations (Component)
  Properties
Property Value
Name OLE_DEST Load Verification table PurchaseOrder Operations
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 1745
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_DEST Load Verification table PurchaseOrder Operations" (1745)
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].[Verify_dbo_DimPurchaseOrder]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Buyer
2148
2109
BuyerId
2147
2106
FiscalYear
1953
1920
PayStatus
2144
2097
PayStatusCode
2143
2094
PoStatus
2140
2085
PoStatusCode
2139
2082
PoType
2146
2103
PoTypeCode
2145
2100
PurchaseOrderAK
2137
2076
PurchaseOrderNumber
2138
2079
ReceivingStatus
2142
2091
ReceivingStatusCode
2141
2088
RowIsDuplicate
1822
552
RowIsSelected
1823
555
  Output Columns
Name ID LineageID
ErrorCode
1760
1760
ErrorColumn
1761
1761
Powered by BI Documenter