|
![]() |
Property | Value |
Name | OLE_DST Load New Temp table for Payable |
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 Payable" (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_DimPayable__New] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
FiscalYear |
7730 |
7583 |
Origin |
8083 |
7950 |
OriginCode |
8082 |
7949 |
PayableAK |
8080 |
7947 |
PayableDate |
8090 |
7957 |
PayableNumber |
8081 |
7948 |
PayableStatus |
8089 |
7956 |
PayableStatusCode |
8088 |
7955 |
PaymentDate |
8091 |
7958 |
PaymentType |
8087 |
7954 |
PaymentTypeCode |
8086 |
7953 |
PaymentTypeNumber |
8187 |
8161 |
PaymentXrefNbr |
8092 |
7959 |
ReferenceNumber |
8186 |
8160 |
ReferenceType |
8085 |
7952 |
ReferenceTypeCode |
8084 |
7951 |
RowEndDate |
7727 |
7579 |
RowIsCurrent |
7725 |
7577 |
RowStartDate |
7726 |
7578 |
Name | ID | LineageID |
ErrorCode |
7687 |
7687 |
ErrorColumn |
7688 |
7688 |
Powered by BI Documenter |