| Value |
 Expression: "
DECLARE @IsFullLoad varchar (1) = '" + @[User::IsFullLoad]+ "'
DECLARE @UseManualDate varchar (1) = '" + @[User::UseManualDates] + "'
DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "'
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
DECLARE @CurrentDayDate date = '" + @[User::CurrentDayDate] + "'
IF @IsFullLoad = 'Y'
BEGIN
SET @IncrementalBeginDtTm = '1900-01-01'
SET @IncrementalEndDtTm = GETDATE()
END
ELSE
IF @UseManualDate = 'N'
BEGIN
SET @IncrementalBeginDtTm = @IncrementalEndDtTm
SET @IncrementalEndDtTm = GETDATE ()
END
DECLARE @TmPortion TIME
DECLARE @DaysToAdd INT = 0
DECLARE @IncrementalEndDt_DateOnly DATE
SET @IncrementalEndDt_DateOnly = CAST(CONVERT(VARCHAR(10), @IncrementalEndDtTm, 101) AS date)
SET @TmPortion = CAST(CONVERT(VARCHAR(20), @IncrementalEndDtTm, 108) AS time)
-- If before 6am, use data up till the end of previous day.
IF @TmPortion < '06:00'
SET @DaysToAdd = -1
ELSE
SET @DaysToAdd
DECLARE @IsFullLoad varchar (1) = 'Y'
DECLARE @UseManualDate varchar (1) = 'N'
DECLARE @IncrementalBeginDtTm datetime = 'Jan 1 1900 12:00AM'
DECLARE @IncrementalEndDtTm datetime = 'Mar 4 2016 10:33AM'
DECLARE @CurrentDayDate date = '2016-03-04'
IF @IsFullLoad = 'Y'
BEGIN
SET @IncrementalBeginDtTm = '1900-01-01'
SET @IncrementalEndDtTm = GETDATE()
END
ELSE
IF @UseManualDate = 'N'
BEGIN
SET @IncrementalBeginDtTm = @IncrementalEndDtTm
SET @IncrementalEndDtTm = GETDATE ()
END
DECLARE @TmPortion TIME
DECLARE @DaysToAdd INT = 0
DECLARE @IncrementalEndDt_DateOnly DATE
SET @IncrementalEndDt_DateOnly = CAST(CONVERT(VARCHAR(10), @IncrementalEndDtTm, 101) AS date)
SET @TmPortion = CAST(CONVERT(VARCHAR(20), @IncrementalEndDtTm, 108) AS time)
-- If before 6am, use data up till the end of previous day.
IF @TmPortion < '06:00'
SET @DaysToAdd = -1
ELSE
SET @DaysToAdd = 0
IF @UseManualDate = 'N'
BEGIN
SET @CurrentDayDate = dateadd(dd,@DaysToAdd,@IncrementalEndDt_DateOnly)
END
-- Update Config variables
UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = @IncrementalBeginDtTm
WHERE ConfigurationFilter = 'Var_IncrementalBeginDtTm'
UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = @IncrementalEndDtTm
WHERE ConfigurationFilter = 'Var_IncrementalEndDtTm'
UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = @CurrentDayDate
WHERE ConfigurationFilter = 'Var_CurrentDayDate'
|
| Expression |
"
DECLARE @IsFullLoad varchar (1) = '" + @[User::IsFullLoad]+ "'
DECLARE @UseManualDate varchar (1) = '" + @[User::UseManualDates] + "'
DECLARE @IncrementalBeginDtTm datetime = '" + @[User::IncrementalBeginDtTm] + "'
DECLARE @IncrementalEndDtTm datetime = '" + @[User::IncrementalEndDtTm] + "'
DECLARE @CurrentDayDate date = '" + @[User::CurrentDayDate] + "'
IF @IsFullLoad = 'Y'
BEGIN
SET @IncrementalBeginDtTm = '1900-01-01'
SET @IncrementalEndDtTm = GETDATE()
END
ELSE
IF @UseManualDate = 'N'
BEGIN
SET @IncrementalBeginDtTm = @IncrementalEndDtTm
SET @IncrementalEndDtTm = GETDATE ()
END
DECLARE @TmPortion TIME
DECLARE @DaysToAdd INT = 0
DECLARE @IncrementalEndDt_DateOnly DATE
SET @IncrementalEndDt_DateOnly = CAST(CONVERT(VARCHAR(10), @IncrementalEndDtTm, 101) AS date)
SET @TmPortion = CAST(CONVERT(VARCHAR(20), @IncrementalEndDtTm, 108) AS time)
-- If before 6am, use data up till the end of previous day.
IF @TmPortion < '06:00'
SET @DaysToAdd = -1
ELSE
SET @DaysToAdd |
Properties
