|
![]() |
Property | Value |
Name | OLE_DST Load New Temp table for PurchaseOrder |
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 PurchaseOrder" (7672) |
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__New] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
Buyer |
8400 |
8278 |
BuyerId |
8399 |
8277 |
FiscalYear |
7730 |
7583 |
PayStatus |
8396 |
8274 |
PayStatusCode |
8395 |
8273 |
PoStatus |
8392 |
8270 |
PoStatusCode |
8391 |
8269 |
PoType |
8398 |
8276 |
PoTypeCode |
8397 |
8275 |
PurchaseOrderAK |
8389 |
8267 |
PurchaseOrderNumber |
8390 |
8268 |
ReceivingStatus |
8394 |
8272 |
ReceivingStatusCode |
8393 |
8271 |
RowEndDate |
7727 |
7579 |
RowIsCurrent |
7725 |
7577 |
RowStartDate |
7726 |
7578 |
Name | ID | LineageID |
ErrorCode |
7687 |
7687 |
ErrorColumn |
7688 |
7688 |
Powered by BI Documenter |