DimPurchaseOrderLoad
 OLE_DST Load SCD1 temp table for PurchaseOrder (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 temp table for PurchaseOrder
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 PurchaseOrder" (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_DimPurchaseOrder__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Buyer
8376
8306
BuyerId
8375
8305
FiscalYear
7705
7611
PayStatus
8372
8302
PayStatusCode
8371
8301
PoStatus
8368
8298
PoStatusCode
8367
8297
PoType
8374
8304
PoTypeCode
8373
8303
PurchaseOrderAK
8365
8295
PurchaseOrderNumber
8366
8296
PurchaseOrderSK
8401
8294
ReceivingStatus
8370
8300
ReceivingStatusCode
8369
8299
  Output Columns
Name ID LineageID
ErrorCode
7670
7670
ErrorColumn
7671
7671
Powered by BI Documenter