|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | DimStudentReceiptDeleteObsoleteRows |
| Description | This package will process any Student and related records that were deleted due to a Student Id Change/Merge process. The first step in this package is to truncate all the working tables that track which Student records will be deleted. The next step will read all the rows in the DimStudent table and check if a matching record is found in the DWStaging ST_STDNT_A table. If a match is not found, the record will be written to a working table. The records in the working table will be used to remove the associated Fact Records and related Student Dimensions. |
| Checkpoint File Name | |
| Checkpoint Usage | Never |
| Check Signature On Load | True |
| Creation Date | Tuesday, May 08, 2012 4:11 PM |
| Creator Computer Name | HETGROUP-PC |
| Creator Name | hetgroup-PC\hstoddar |
| 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 | 5f89e16e-722e-4e51-a8ab-e170986be8df |
| 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 | EncryptSensitiveWithUserKey |
| Save Checkpoints | False |
| Suppress Configuration Warnings | False |
| Suspend Required | False |
| Transaction Option | Supported |
| Update Objects | False |
| Version Build | 260 |
| Version Comments | |
| Version Guid | e0bb5773-482f-42f3-ac81-1fb68d023ffd |
| Version Major | 1 |
| Version Minor | 0 |
Executables
| Name | Type | Description |
Task |
Execute SQL Task |
Connection Managers
| Name | Description |
Log Providers
| Name | Description |
User Defined Variables
| Name | Value | Expression | Description |
EnterpriseDW |
Configuration setting in SSIS_Configurations that specifies the name of the Enterprise Data Warehouse. |
||
N/A |
If the Enterprise Data Warehouse resides on a different server from the DWStaging and DWoperations databases, a linked server must be defined and the name populated into the Var_EDWLinkedServername. If it resides on the same server, this setting must be set to ?N/A?. This is a configuration setting from SSIS_Configurations. |
||
/* Remove Student Receipt Rows from DimStudentReceipt for Old Students */
DELETE StRec
FROM
[EnterpriseDW].[dbo].[DimStudentReceipt] AS StRec WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StRec.StudentId = OldSt.OldStudentIdAK
)
|
"
/* Remove Student Receipt Rows from DimStudentReceipt for Old Students */
DELETE StRec
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentReceipt] AS StRec WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StRec.StudentId = OldSt.OldStudentIdAK
)
" |
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
