FactGlTransactionsLoad
 OLE DB Load into FactGlTransactions (Component)
  Properties
Property Value
Name OLE DB Load into FactGlTransactions
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 1535
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 DB Load into FactGlTransactions" (1535)
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].[FactGlTransactions]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
ActualsAmount
1844
1700
ActualsAmountCredit
1582
1462
ActualsAmountDebit
1581
1404
BudgetAmount
1841
1691
BudgetAmountCredit
1580
1401
BudgetAmountDebit
1579
1398
CalendarDateSK
1595
618
CommitmentAmount
1842
1694
CommitmentAmountCredit
1584
1468
CommitmentAmountDebit
1583
1465
EncumbranceAmount
1843
1697
EncumbranceAmountCredit
1586
1474
EncumbranceAmountDebit
1585
1471
GlAccountSK
1592
1330
GlCodeSK
1590
1188
GlDetailSK
1839
1789
JournalAmount
1840
1688
JournalAmountCredit
1588
1480
JournalAmountDebit
1587
1477
OrgUnitSK
1589
1182
PostedDateSK
1593
1217
  Output Columns
Name ID LineageID
ErrorCode
1550
1550
ErrorColumn
1551
1551
Powered by BI Documenter