FactCheckSummaryLoad
 OLE DB Load into FactCheckSummary (Component)
  Properties
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
  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].[FactCheckSummary]
OpenRowsetVariable
SqlCommand
  Input Columns
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
  Output Columns
Name ID LineageID
ErrorCode
1550
1550
ErrorColumn
1551
1551
Powered by BI Documenter