FactPositionExpenseLoad
 OLE DB Load into FactPositionExpense (Component)
  Properties
Property Value
Name OLE DB Load into FactPositionExpense
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 FactPositionExpense" (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].[FactPositionExpense_Staging]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
AssignmentAK
2481
2461
BudgetedAK
2476
2446
CheckDateAK
2477
2449
CheckTypeAK
2478
2452
CompensationTypeAK
2475
2443
EmployeeAK
2479
2455
ExpenseAmount
2485
2473
GlAccountAK
2484
2470
GlCodeAK
2483
2467
OrgUnitAK
2482
2464
PositionAK
2480
2458
  Output Columns
Name ID LineageID
ErrorCode
1550
1550
ErrorColumn
1551
1551
Powered by BI Documenter