2016-03-04

This is a configuration setting in SSIS_Configurations that is set to the date that the package is being executed on.

System.Object

This contains the result set of a SQL query that will return the list of terms that need to be processed.

EXEC usp_FactArchivedEnrollmentSnapshot_FullSelect '2016-03-04' , ''

"EXEC usp_FactArchivedEnrollmentSnapshot_FullSelect '" + @[User::CurrentDayDate] + "' , '" + @[User::TermResults] + "'"

The SQL statement that will execute the stored procedure to extract the data from the archived Student Class Log file in the Source system. This variable is used during a Full Load.

EXEC usp_FactActiveEnrollmentSnapshot_FullSelect '2016-03-04' , ''

"EXEC usp_FactActiveEnrollmentSnapshot_FullSelect '" + @[User::CurrentDayDate] + "' , '" + @[User::TermResults] + "'"

The SQL statement that will execute the stored procedure to extract the data from the Student Class Log file in the Source system. This is used during a full load.

Select '19981' as StartTerm

" Select '" + @[User::StartTermFullLoad] + "' as StartTerm "

This variable contain the SQL Statement that will populate the StartTermFullLoad parameter into a Result Set.

19981

This is a configuration setting from SSIS_Configurations that determines which terms to load Enrollment information into the End of Term Enrollment Fact table.

This is a user varaible that is used in a FOR EACH container to process data one term at a time.