CTL Load DW_SuccessRetention
 SetRowCount (Variable)
  Properties
Property Value
Name SetRowCount
Value Expression: " 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 "

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
Value Type String
Description
System Variable False
Namespace User
Qualified Name User::SetRowCount
Evaluate As Expression True
Expression " 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 "
ID 8deb6c01-902f-4db8-9549-bd8bffe1f96e
Raise Changed Event False
Powered by BI Documenter