November 13, 2014 at 2:08 pm
Is there a way to tell a task to run base off of time? For example I have 4 task. One task runs then if the time is between 12:00pm - 1:00pm Run 'TASK A' else if it is not 12:00pm - 1:00pm then run 'TASK B' then goes to the last task.
November 13, 2014 at 2:18 pm
Add expressions to each task that disable the tasks based on the time
Gerald Britton, Pluralsight courses
November 13, 2014 at 2:29 pm
g.britton (11/13/2014)
Add expressions to each task that disable the tasks based on the time
So i would set the property in Expression to 'Disable' it seems. What would i set the expression as? Do i need to create any variables?
November 14, 2014 at 5:55 am
Add a task to the top of the process that sets a variable to be the system time, then on the success arrows from first Execute SQL task, set the path to be conditional on whether the variable says before or after the cutoff time.
If the sproc takes a long time to run and you need to know the time AFTER it has run then put the variable update as the output of the sproc and then the conditonal flows based as output from the task.
Does the package run persistently or is it called from some sort of scheduler?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply