|
![]() |
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 |
Name | Connection Manager | Description |
OleDbConnection |
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 |
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 |
Name | ID | LineageID |
ErrorCode |
7670 |
7670 |
ErrorColumn |
7671 |
7671 |
Powered by BI Documenter |