|
![]() |
Property | Value |
Name | OLE DB Load into FactCheckSummary |
Description | OLE DB Destination |
Up Stream Components | |
Down Stream Components | none |
ID | 1535 |
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 DB Load into FactCheckSummary" (1535) |
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].[FactCheckSummary] |
OpenRowsetVariable |
|
SqlCommand |
Name | ID | LineageID |
Benefits |
2859 |
2650 |
BenefitsAdjusted |
2860 |
2653 |
BenefitsTaxable |
2861 |
2656 |
BenefitsTaxableAdjusted |
2862 |
2659 |
CheckDateSK |
2840 |
2690 |
CheckIssuedDateSK |
2838 |
2710 |
CheckNet |
2869 |
2680 |
CheckNumber |
2845 |
2608 |
CheckProcessed |
2846 |
2611 |
CheckReissued |
2849 |
2620 |
CheckTypeSK |
2841 |
2685 |
CheckVoidedCancelled |
2847 |
2614 |
DeductionsPostTax |
2865 |
2668 |
DeductionsPostTaxAdjustments |
2866 |
2671 |
DeductionsPreTax |
2863 |
2662 |
DeductionsPreTaxAdjustments |
2864 |
2665 |
DirectDeposit |
2848 |
2617 |
EmployeeSK |
2554 |
2398 |
Gross |
2852 |
2629 |
GrossAdjusted |
2853 |
2632 |
GrossMinusTaxes |
2858 |
2647 |
GrossOvertime |
2855 |
2638 |
GrossOvertimeAdjusted |
2857 |
2644 |
GrossRegular |
2854 |
2635 |
GrossRegularAjusted |
2856 |
2641 |
HoursNormal |
2850 |
2623 |
HoursOvertime |
2851 |
2626 |
PayrollProcessedDateSK |
2839 |
2749 |
Taxes |
2867 |
2674 |
TaxesAdjusted |
2868 |
2677 |
Name | ID | LineageID |
ErrorCode |
1550 |
1550 |
ErrorColumn |
1551 |
1551 |
Powered by BI Documenter |