FactEnrollmentSnapshotLoad
 FELC Loop Thru Main Tables (ForEach Loop)
Home  Diagrams  Documents  Images  FactEnrollmentSnapshotLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  FactEnrollmentSnapshotLoad   FELC Get Data from Staging for each Term   FELC Loop Thru Main Tables
  Properties
Property Value
Name FELC Loop Thru Main Tables
Description Foreach Loop Container
Precedence Executables none
Contrained Executables none
ID bc5949af-53a3-4490-8c96-159fedb1c134
Delay Validation False
Disable False
Disable Event Handlers False
Fail Package On Failure False
Fail Parent On Failure False
Force Execution Result None
Force Execution Value False
Isolation Level Serializable
Locale ID 1033
Logging Mode UseParentSetting
Suspend Required False
Transaction Option Supported
ForEachEnumerator.CollectionEnumerator True
ForEachEnumerator.CreationName Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator, Microsoft.SqlServer.ForEachADOEnumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ForEachEnumerator.DataObjectVariable User::EnrollmentTermsAndDays_MainQueue
ForEachEnumerator.Description
ForEachEnumerator.ID {061776db-da9a-4fa4-ac92-32eb2e5be9cc}
ForEachEnumerator.Name {FCAB6FA7-FAB1-49D6-8867-5140A358CC26}
ForEachEnumerator.Type 2
ForEachEnumerator.VariableMappings 0 , User::TermResults
1 , User::CurrentDayDateForFactLoad
ForEachEnumerator.Version 0
  Executables
Name Type Description
Data Flow Task
Data Flow Task
  Variables
Name Value Description
Expression: "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::TermResults] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::CurrentDayDate] + "' "

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]) <= '2016-03-04'
This variable contains the Select Statement to copy Prior Year Enrollment from Staging to DWOperations
Expression: "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::TermList] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::CurrentDayDate] + "' "

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]) <= '2016-03-04'
This variable contains the Select Statement to copy Prior Year Enrollment from Staging to DWOperations
2011-09-01
Expression: "EXEC usp_FactEnrollmentSS_Select '" + @[User::CurrentDayDateForFactLoad] + "' , '" + @[User::TermResults] + "'"

EXEC usp_FactEnrollmentSS_Select '2011-09-01' , ''
This is the SQL statement to execute a Stored Procedure to retrieve data from the Student Class Log file in the source system.
This variable is used in a For Each Loop container to extract data for each active term.
This variable is used in a For Each Loop container to extract data for each active term.
Powered by BI Documenter