|
![]() |
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 |
Name | Connection Manager | Description |
OleDbConnection |
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 |
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 |
Name | ID | LineageID |
ErrorCode |
1760 |
1760 |
ErrorColumn |
1761 |
1761 |
Powered by BI Documenter |