DimAssignmentLoad
 OLE_DEST Load Verification table Assignment Operations (Component)
  Properties
Property Value
Name OLE_DEST Load Verification table Assignment 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 Assignment 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_DimAssignment]
OpenRowsetVariable
SqlCommand
  Input Columns
Name ID LineageID
ActualSalary
2825
2689
AssignmentAK
2802
2617
AssignmentEndDateRange
2821
2674
AssignmentFulltimeParttime
2820
2671
AssignmentSequenceNumber
2804
2623
AssignmentStatus
2806
2629
AssignmentType
2808
2635
AssignmentTypeCode
2807
2632
BaseSalary
2824
2686
DailyRate
2826
2692
EndBasis
2823
2683
EndBasisCode
2822
2680
EndDate
2810
2641
ExemptStatus
2819
2668
FunctionCode
2799
2043
FunctionDescription
2832
2046
HourlyRate
2827
2695
InstitutionalAssignmentType
2816
2659
InstitutionalAssignmentTypeCode
2815
2656
JobClassCode
2813
2650
JobGroup
2812
2647
JobGroupCode
2811
2644
JobTitle
2805
2626
LastPaymentDateRange
2870
2835
OvertimeRate
2828
2698
PayBasis
2814
2653
PersonID
2801
2196
PositionCode
2803
2620
PrimaryAssignment
2817
2662
PrimarySalaryAccountNumber
2800
2082
RegularTemporary
2818
2665
RowIsDuplicate
2830
552
RowIsSelected
2831
555
StartDate
2809
2638
TotalSalary
2829
2701
  Output Columns
Name ID LineageID
ErrorCode
1760
1760
ErrorColumn
1761
1761
Powered by BI Documenter