I am trying to add a step in my SSIS job where it checks a table (FYI, so this table has only 1column which is a datetime data type that gets updated daily with a datetime from another table) whether it is greater than midnight or not. how do I setup this with the appropriate query.
This is the table name - ETLTimeCheck This is the only column in this table- EXEC_END_TIME
I started out with this idea:
SELECT... FROM [dbo].[ETLTimeCheck] WHERE [EXEC_END_TIME] > DATEADD(D,0,DATEDIFF(D,0,GETDATE()))
This is suppose to return a midnight->
I know there must be an 'IF' statement inside my query. Can you please help me finish this?