|
|
||||||
|
|
||||||
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 |
