OLE_DST Load SCD1 Temp table for Assignment

Property	Value
Name	OLE_DST Load SCD1 Temp table for Assignment
Description	OLE DB Destination
Up Stream Components	TF_SCD DimAssignment
Down Stream Components	none
ID	7113
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_DST Load SCD1 Temp table for Assignment" (7113)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	4

Name	Connection Manager	Description
OleDbConnection	DWOperations

Name	Value
AccessMode	3
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
FastLoadKeepIdentity	False
FastLoadKeepNulls	False
FastLoadMaxInsertCommitSize	2147483647
FastLoadOptions	TABLOCK,CHECK_CONSTRAINTS
OpenRowset	[dbo].[Staged_dbo_DimAssignment__Type1Update]
OpenRowsetVariable
SqlCommand

Name	ID	LineageID
ActualSalary	9857	9697
AssignmentAK	9832	9672
AssignmentEndDateRange	9852	9692
AssignmentFulltimeParttime	9851	9691
AssignmentSequenceNumber	9835	9675
AssignmentStatus	9837	9677
AssignmentType	9839	9679
AssignmentTypeCode	9838	9678
BaseSalary	9856	9696
DailyRate	9858	9698
EndBasis	9855	9695
EndBasisCode	9854	9694
EndDate	9841	9681
ExemptStatus	9850	9690
FunctionCode	8409	8268
FunctionDesc	9188	8998
HourlyRate	9859	9699
InstitutionalAssignmentType	9847	9687
InstitutionalAssignmentTypeCode	9846	9686
JobClassCode	9844	9684
JobGroup	9843	9683
JobGroupCode	9842	9682
JobTitle	9836	9676
LastPaymentDateRange	9853	9693
OvertimeRate	9860	9700
PayBasis	9845	9685
PersonId	9833	9673
PositionCode	9834	9674
PrimaryAssignment	9848	9688
PrimarySalaryAccountNumber	8422	8281
RegularTemporary	9849	9689
StartDate	9840	9680
TotalSalary	9861	9701