Is it possible to make task run only during specific time in ETL?

Question

In an SSIS Package which is working fine and executing every hour. I want to add a task to execute only for the batch which runs at 8am

Means I want to add and notification email task at particular hour only. Is this possible to check time and execute the flow else just continue to execute the ETL as normal.

I know i can create a separate ETL and scheduled it run, just trying to see if I can avoid one more ETL and one more job for this.

SSIS 2015 and SQL Server 2016 are the version I am using.

Answer 1

Hi @Neil ,

We can add an empty Sequence Container and a Send Mail Task, Data Flow Task.
We can set the Precedence Constraint between Sequence Container and Send Mail Task.
Please refer to the following pictures:

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Maybe try having some task that will give the time like Execute SQL task and run getdate() and get time part from it

Add condition in precedent constraint - If time is 8 AM only then run the connected next task that you want to run.

Not sure if it is really possible as you might have multiple tasks that you don't want run along

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 3

Thanks Vibhav and Monal, this looks good and it should work.
I will build this and test.