DimPositionLoad
 OLE_DEST Load Verification table Position Operations (Component)
  Properties
Property Value
Name OLE_DEST Load Verification table Position Operations
Description OLE DB Destination
Up Stream Components
Down Stream Components none
ID 1745
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_DEST Load Verification table Position Operations" (1745)
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].[Verify_dbo_DimPosition]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
Budgeted
2179
2450
CountOfActiveAssignments
2185
2468
CountOfInactiveAssignments
2186
2471
DateEstablished
2173
2432
DateInactivated
2174
2435
ExempStatus
2182
2459
FulltimeEquivalent
2190
2483
FunctionCode
2171
2420
FunctionDescription
2172
2423
InactiveReason
2188
2477
InactiveReasonCode
2187
2474
InactiveVacantDateRange
2524
2492
JobClassCode
2177
2444
JobGroup
2176
2441
JobGroupCode
2175
2438
Location
2490
2429
LocationCode
2489
2426
MultipleFunds
2559
2526
PayBasis
2178
2447
PooledIndicator
2181
2456
PositionAK
2160
2402
PositionCode
2161
2405
PositionFulltimeParttime
2183
2462
PositionStatus
2163
2411
PositionTitle
2162
2408
PositionType
2170
2417
PositionTypeCode
2164
2414
PrimarySalaryAccountNumber
2184
2465
RegularTemporary
2180
2453
RowIsDuplicate
1822
552
RowIsSelected
1823
555
WeeklyAuthorizedHours
2191
2486
  Output Columns
Name ID LineageID
ErrorCode
1760
1760
ErrorColumn
1761
1761
Powered by BI Documenter