|
![]() |
Property | Value |
Name | OLE_DST Load SCD1 temp table for Payable |
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 Payable" (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_DimPayable__Type1Update] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
FiscalYear |
7705 |
7611 |
Origin |
8056 |
7980 |
OriginCode |
8055 |
7979 |
PayableAK |
8052 |
7977 |
PayableDate |
8063 |
7987 |
PayableNumber |
8054 |
7978 |
PayableSK |
8053 |
7976 |
PayableStatus |
8062 |
7986 |
PayableStatusCode |
8061 |
7985 |
PaymentDate |
8064 |
7988 |
PaymentType |
8060 |
7984 |
PaymentTypeCode |
8059 |
7983 |
PaymentTypeNumber |
8183 |
8167 |
PaymentXrefNbr |
8065 |
7989 |
ReferenceNumber |
8182 |
8166 |
ReferenceType |
8058 |
7982 |
ReferenceTypeCode |
8057 |
7981 |
Name | ID | LineageID |
ErrorCode |
7670 |
7670 |
ErrorColumn |
7671 |
7671 |
Powered by BI Documenter |