|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | FactEOTEnrollmentSnapshotLoad |
| Description | This package will extract the Enrollment Information for all terms equal to or greater than the term specified in the StartTermFullLoad configuration setting. One row per student per term per class will be created if the Student was enrolled on the day for which the package is executed. The data in the FactEOTEnrollmentSnapshot will be deleted and re-created during each execution. |
| Checkpoint File Name | |
| Checkpoint Usage | Never |
| Check Signature On Load | True |
| Creation Date | Tuesday, May 08, 2012 4:11 PM |
| Creator Computer Name | SCOWAN |
| Creator Name | SCOWAN\hetgroup |
| Debug Mode | False |
| Delay Validation | False |
| Disable | False |
| Disable Event Handlers | False |
| Enable Configurations | True |
| Encrypt Checkpoints | False |
| Fail Package On Failure | False |
| Fail Parent On Failure | False |
| Forced Execution Value | 0 |
| Force Execution Value | None |
| Description | False |
| ID | 30a73bd2-78af-4db2-aa31-e5bb8254726b |
| Interactive Mode | False |
| Is Default Locale ID | False |
| Isolation Level | Serializable |
| Locale ID | 1033 |
| Logging Mode | Enabled |
| Max Concurrent Executables | -1 |
| Maximum Error Count | 1 |
| Offline Mode | False |
| Package Type | DTSDesigner100 |
| Protection Level | DontSaveSensitive |
| Save Checkpoints | False |
| Suppress Configuration Warnings | False |
| Suspend Required | False |
| Transaction Option | Supported |
| Update Objects | False |
| Version Build | 229 |
| Version Comments | |
| Version Guid | a8441ef0-9fcc-4c3f-9303-1b79cf4bd080 |
| Version Major | 1 |
| Version Minor | 0 |
Executables
| Name | Type | Description |
Data Flow Task |
Data Flow Task |
|
For Each Loop |
Foreach Loop Container |
|
Task |
Execute SQL Task |
|
Task |
Execute SQL Task |
|
Task |
Execute SQL Task |
Connection Managers
| Name | Description |
Log Providers
| Name | Description |
User Defined Variables
| Name | Value | Expression | Description |
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. |
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
