Data Flow Task

Data Flow Task

For Each Loop

Foreach Loop Container

Task

Execute SQL Task

Task

Execute SQL Task

Task

Execute SQL Task

This variable will contain the Active Terms for which data will be extracted.

SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG_ARCH_A] st_clslog WHERE EFF_TRM = '' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= ''

"SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG_ARCH_A] st_clslog WHERE EFF_TRM = '" + @[User::PriorYearTermResults] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::PriorYearDateResults] + "' "

This variable contains the Select Statement to copy Prior Year Enrollment from the Archived Student Class log file in Staging to DWOperations

SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG] st_clslog WHERE EFF_TRM = '' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= ''

"SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG] st_clslog WHERE EFF_TRM = '" + @[User::PriorYearTermResults] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::PriorYearDateResults] + "' "

This variable contains the Select Statement to copy Prior Year Enrollment from Staging to DWOperations

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 variable will contain the result set with Active Terms, Prior Terms and Prior Term Relative dates for which data should be extracted.

EXEC usp_FactEnrollmentSS_Select '' , ''

"EXEC usp_FactEnrollmentSS_Select '" + @[User::PriorYearDateResults] + "' , '" + @[User::PriorYearTermResults] + "'"

This is the SQL statement that will execute a Stored Procedure to extract the data from the Student Class Log file.

0

This variable will contain the Relative Day number for the Prior Year Terms for which data is extracted.

This variable will contain the actual date associated with the same relative day for the Prior Terms for which data is extracted.

This variable will contain the Prior Year Terms for which data will be extracted based on the Active Terms.