|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | DimStudentTermDeleteObsoleteRows |
| Description | This package deletes records from the DimStudentTerm dimension where the associated StudentId is listed in the DWOperations.dbo.Obsolete_DimStudent table. That table is populated in the SSIS package ObsoleteDimStudentLoad.dtsx. |
| 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 | d3e78065-e2d7-4681-b218-52a9ef2fcfe5 |
| 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 | 254 |
| Version Comments | |
| Version Guid | 2b5347b4-7ee9-4e60-900e-9104a2d543b4 |
| 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 |
Configuration setting from SSIS_Configuration to specify the domain where the e-mail server is running. |
|||
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 Term Rows from DimStudentTerm for Old Students */
DELETE StTerm
FROM
[EnterpriseDW].[dbo].[DimStudentTerm]
as StTerm
WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StTerm.StudentId = OldSt.OldStudentIdAK
)
|
"
/* Remove Student Term Rows from DimStudentTerm for Old Students */
DELETE StTerm
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentTerm]
as StTerm
WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StTerm.StudentId = OldSt.OldStudentIdAK
)
" |
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
