DECLARE @WaitForTime  datetime
DECLARE @StopWaitTime  datetime
DECLARE @WaitIncrement int
DECLARE @StopIncrement int
DECLARE @PackageRetVal int
DECLARE @ReturnValue  int

SET @ReturnValue = 0
SET @WaitIncrement = 5
SET @StopIncrement = 90
SET @WaitForTime = DATEADD(minute, @WaitIncrement, getdate())
SET @StopWaitTime = DATEADD(minute, @StopIncrement, getdate())

WHILE (@WaitForTime < @StopWaitTime)
BEGIN
	SELECT top 1 @PackageRetVal = DataCode
	FROM dbo.sysssislog (NOLOCK)
	WHERE	source like 'Import_SQLPlexStaging_Statusmart_DailyApps'
	AND		[event] = 'PackageEnd'
	AND		DATEDIFF(mi, StartTime, getdate()) < 90
	ORDER BY ID desc

	IF @PackageRetVal is not null
	BEGIN
		IF @PackageRetVal = 0 -- no error
			SET @ReturnValue = 1
		ELSE
			SET @ReturnValue = 0
			
		BREAK
	END

	IF (getdate() >= @StopWaitTime)
	 BEGIN
		SET @ReturnValue = 0 -- timed out
		BREAK
	 END

	 WAITFOR Time @WaitForTime
	 
	 SET @WaitForTime = DATEADD(minute, @WaitIncrement, getdate())
END

SELECT TodaysDate = getdate()

SELECT Results = @ReturnValue