DFT Load Temp Employee Table for Verification

Property	Value
Name	DFT Load Temp Employee Table for Verification
Description	Data Flow Task
Precedence Executables	none
Contrained Executables	none
ID	0749aec0-9d73-46bf-a2ee-5d715616e929
BLOB Temp Storage Path
Buffer Temp Storage Path
Default Buffer Max Rows	10000
Default Buffer Size	10485760
Run In Optimized Mode	True
Locale ID	English (United States)
Logging Mode	UseParentSetting
Forced Execution Value	0
Force Execution Value	False
Delay Validation	False
Disable	False
Disable Event Handlers	False
Fail Package On Failure	False
Fail Parent On Failure	False
Maximum Error Count	1
Isolation Level	Serializable
Suspend Required	False
Transaction Option	Supported

Name	Type	Description
DER Check for NULLS	12	Updates column values using expressions
DER Stub Fields	12	Updates column values using expressions
Lookup County and CountyFIPS	12	Looks up values in a reference dataset by using exact matching.
OLE_DEST Load Verification table Employee Operations	10	OLE DB Destination
OLE_SRC Verification Temp table from EMPLOYEE_A Staging and NON_EMPLOYEE_A Staging	9	OLE DB Source

Component	Input Column	Destination Column
DER Check for NULLS
Derived Column Input
	County [?]	County
	CountyFIPS [?]	CountyFIPS
DER Stub Fields
Derived Column Input
	ZipCode [?]	ZipCode
Lookup County and CountyFIPS
Lookup Input
	ZipCode5 [?]	ZipCode5
OLE_DEST Load Verification table Employee Operations
OLE DB Destination Input
	Citizenship [?]	Citizenship
	CitizenshipCode [?]	CitizenshipCode
	Country [?]	Country
	CountryCode [?]	CountryCode
	CountryOfCitizenship [?]	CountryOfCitizenship
	CountryOfCitizenshipCode [?]	CountryOfCitizenshipCode
	County [?]	County
	CountyFIPS [?]	CountyFIPSCode
	DateOfBirth [?]	DateOfBirth
	EmployeeAK [?]	EmployeeAK
	EmployeeFulltimeParttime [?]	EmployeeFulltimeParttime
	EmployeeStudentId [?]	EmployeeStudentId
	EmployeeType [?]	EmployeeType
	EmployeeTypeCode [?]	EmployeeTypeCode
	Ethnicity [?]	Ethnicity
	EthnicityCode [?]	EthnicityCode
	FirstName [?]	FirstName
	FullName [?]	FullName
	FunctionCode [?]	FunctionCode
	FunctionDescription [?]	FunctionDesc
	Gender [?]	Gender
	GenderCode [?]	GenderCode
	HasActiveAssignment [?]	HasActiveAssignment
	HasDirectDeposit [?]	HasDirectDeposit
	HireDate [?]	HireDate
	IsStudent [?]	IsAStudent
	LastActiveAssignmentDateRange [?]	LastActiveAssignmentDateRange
	LastName [?]	LastName
	LastPayCheckDateRange [?]	LastPayCheckDateRange
	Location [?]	Location
	LocationCode [?]	LocationCode
	MiddleInitial [?]	MiddleInitial
	NumberOfActiveAssignments [?]	NumberOfActiveAssignments
	PersonID [?]	PersonID
	PositionType [?]	PositionType
	PositionTypeCode [?]	PositionTypeCode
	PrimarySalaryAccountNumber [?]	PrimarySalaryAccountNumber
	RowIsDuplicate [?]	RowIsDuplicate
	RowIsSelected [?]	RowIsSelected
	State [?]	State
	StateCode [?]	StateCode
	TerminationDate [?]	TerminationDate
	TerminationDateRange [?]	TerminationDateRange
	YearsOfServiceToInstitution [?]	YearsOfServiceToInstitution
	ZipCode [?]	ZipCode

Name	Value	Description
User::IncrementalBeginDtTm	May 14 2014 1:03PM	The IncrementalBeginDtTm setting will contain the start date and time for which updates will be extracted. This is a configuration setting from SSIS_Configurations that are set in the Control Package.