DimPositionLoad
 OLE_DST Load SCD1 Temp table for Position (Component)
  Properties
Property Value
Name OLE_DST Load SCD1 Temp table for Position
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 7113
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 Position" (7113)
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__Type1Update]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Budgeted
8417
8276
CountOfActiveAssignments
8423
8282
CountOfInactiveAssignments
8424
8283
DateEstablished
8411
8270
DateInactivated
8412
8271
ExemptStatus
8420
8279
FulltimeEquivalent
8428
8287
FunctionCode
8409
8268
FunctionDescription
8410
8269
InactiveReason
8426
8285
InactiveReasonCode
8425
8284
InactiveVacantDateRange
8607
8598
JobClassCode
8415
8274
JobGroup
8414
8273
JobGroupCode
8413
8272
Location
8553
8537
LocationCode
8552
8536
MultipleFunds
8661
8650
PayBasis
8416
8275
PooledIndicator
8419
8278
PositionAK
8403
8262
PositionCode
8404
8263
PositionFulltimeParttime
8421
8280
PositionStatus
8406
8265
PositionTitle
8405
8264
PositionType
8408
8267
PositionTypeCode
8407
8266
PrimarySalaryAccountNumber
8422
8281
RegularTemporary
8418
8277
WeeklyAuthorizedHours
8429
8288
  Output Columns
Name ID LineageID
ErrorCode
7128
7128
ErrorColumn
7129
7129
Powered by BI Documenter