DimPositionLoad
 OLE_DST Load New Temp table for Position (Component)
  Properties
Property Value
Name OLE_DST Load New Temp table for Position
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7189
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 Position" (7189)
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].[Staged_dbo_DimPosition__New]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Budgeted
8471
8220
CountOfActiveAssignments
8477
8226
CountOfInactiveAssignments
8478
8227
DateEstablished
8465
8214
DateInactivated
8466
8215
ExemptStatus
8474
8223
FulltimeEquivalent
8482
8231
FunctionCode
8463
8212
FunctionDescription
8464
8213
InactiveReason
8480
8229
InactiveReasonCode
8479
8228
InactiveVacantDateRange
8609
8594
JobClassCode
8469
8218
JobGroup
8468
8217
JobGroupCode
8467
8216
Location
8557
8531
LocationCode
8556
8530
MultipleFunds
8663
8646
PayBasis
8470
8219
PooledIndicator
8473
8222
PositionAK
8457
8206
PositionCode
8458
8207
PositionFulltimeParttime
8475
8224
PositionStatus
8460
8209
PositionTitle
8459
8208
PositionType
8462
8211
PositionTypeCode
8461
8210
PrimarySalaryAccountNumber
8476
8225
RegularTemporary
8472
8221
RowEndDate
7699
7691
RowIsCurrent
7697
7667
RowStartDate
7698
7683
WeeklyAuthorizedHours
8483
8232
  Output Columns
Name ID LineageID
ErrorCode
7204
7204
ErrorColumn
7205
7205
Powered by BI Documenter