|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | FELC Loop Thru Archive Tables |
| Description | Foreach Loop Container |
| Precedence Executables | none |
| Contrained Executables | none |
| ID | d5c8ce60-d8e0-4fd5-b7dd-a4b9bb382a94 |
| 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_ArchiveQueue |
| ForEachEnumerator.Description | |
| ForEachEnumerator.ID | {0A187900-08C3-48A6-BEDB-B99D6245CC1D} |
| 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_ARCH_A] 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_ARCH_A] 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 Enrollment from Archived Stdnt Class Log in 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_ARCH_A] st_clslog
WHERE EFF_TRM = '" + @[User::TermList_archived] + "'
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_ARCH_A] 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 Enrollment from Archived Stdnt Class Log in Staging to DWOperations |
|
2011-09-01 |
||
| Expression: "EXEC usp_FactArchivedEnrollmentSS_Select '" + @[User::CurrentDayDateForFactLoad] + "' , '" + @[User::TermResults] + "'" EXEC usp_FactArchivedEnrollmentSS_Select '2011-09-01' , '' |
This is the SQL statement to execute a Stored Procedure to retrieve data from the archived 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. |
| Powered by BI Documenter |
