|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | CTL Load DW_SuccessRetention |
| Description | This package will execute all the packages to load the EnterpriseDW with all the Dimensions and Fact tables. The first step in the package is to set the Incremental Start and End Dates and the Current Day Date for use within the rest of the packages. |
| Checkpoint File Name | |
| Checkpoint Usage | Never |
| Check Signature On Load | True |
| Creation Date | Tuesday, May 08, 2012 4:11 PM |
| Creator Computer Name | ipeterson |
| Creator Name | ipeterso\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 | 25f3d92e-d656-4182-947d-077c4eb08391 |
| 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 | 274 |
| Version Comments | |
| Version Guid | f283a33e-8032-48da-be47-1f8a4482497c |
| Version Major | 1 |
| Version Minor | 0 |
Executables
| Name | Type | Description |
Sequence |
Sequence Container |
|
Task |
Execute SQL Task |
|
Task |
Execute SQL Task |
Connection Managers
| Name | Description |
Log Providers
| Name | Description |
User Defined Variables
| Name | Value | Expression | Description |
EnterpriseDW |
|||
N/A |
|||
Jan 1 1900 12:00AM |
|||
Mar 4 2016 10:33AM |
|||
Y |
|||
C:\Data Warehouse\Project\SSIS\EnterpriseDW_SSIS\ |
The contains the folder where the SSIS packages are stored. This is used in the connection string in the Control package to execute all the SSIS packages. |
||
0 |
|||
0 |
|||
SELECT
(
SELECT COUNT(*)
FROM Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactInstitutionalRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactProgramRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactStudentSuccess_FirstYearSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN [EnterpriseDW].[dbo].FactStudentSuccess_TermSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK)
) AS TotalRowCount
|
"
SELECT
(
SELECT COUNT(*)
FROM Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactInstitutionalRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactProgramRetentionSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactStudentSuccess_FirstYearSnapshot Fact
ON
(Obs.OldStudentSK = Fact.StudentSK))
+
(SELECT COUNT(*)
from Obsolete_DimStudent Obs
INNER JOIN " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].FactStudentSuccess_ |
||
DECLARE @IncrementalBeginDtTm datetime = 'Jan 1 1900 12:00AM'
DECLARE @IncrementalEndDtTm datetime = 'Mar 4 2016 10:33AM'
IF 1=2
BEGIN
SELECT 0 AS RowsUpdated
END
SELECT
COUNT(*) AS RowsUpdated
FROM dbo.ST_STDNT_ENDOFTERM_A
WHERE
RowUpdatedOn >= @IncrementalBeginDtTm
AND RowUpdatedOn <= @IncrementalEndDtTm
|
"
DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "'
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
IF 1=2
BEGIN
SELECT 0 AS RowsUpdated
END
SELECT
COUNT(*) AS RowsUpdated
FROM dbo.ST_STDNT_ENDOFTERM_A
WHERE
RowUpdatedOn >= @IncrementalBeginDtTm
AND RowUpdatedOn <= @IncrementalEndDtTm
" |
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
