DFT Load FactEOTEnrollment Staging Table Full Load

Property	Value
Name	DFT Load FactEOTEnrollment Staging Table Full Load
Description	Data Flow Task
Precedence Executables	none
Contrained Executables	none
ID	c13984b0-fe7c-475b-87b4-b6f03ec82570
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
Merge Current and Archived Enrollment	12	Merges two sorted datasets.
OLE DB EOT Enrollment Staging	10	OLE DB Destination
OLE_SRC EOT Archived Enrollment from Staging	9	OLE DB Source
OLE_SRC EOT Enrollment from Staging	9	OLE DB Source

Component	Input Column	Destination Column
Merge Current and Archived Enrollment
Merge Input 1
	EFF_TRM [?]	EFF_TRM
	Enrolled [?]	Enrolled
	EnrollmentDate [?]	EnrollmentDate
	PaidEnrollment [?]	PaidEnrollment
	REF_NUM [?]	REF_NUM
	STDNT_ID [?]	STDNT_ID
Merge Input 2
	EFF_TRM [?]	EFF_TRM
	Enrolled [?]	Enrolled
	EnrollmentDate [?]	EnrollmentDate
	PaidEnrollment [?]	PaidEnrollment
	REF_NUM [?]	REF_NUM
	STDNT_ID [?]	STDNT_ID
OLE DB EOT Enrollment Staging
OLE DB Destination Input
	EFF_TRM [?]	EFF_TRM
	Enrolled [?]	Enrolled
	EnrollmentDate [?]	EnrollmentDate
	PaidEnrollment [?]	PaidEnrollment
	REF_NUM [?]	REF_NUM
	STDNT_ID [?]	STDNT_ID

Name

Value

Description