Mark Wilson
asked on
Disabling Data Flow Task
I have developed a SSIS package which has 4 data flow tasks which run in sequence and is scheduled on a daily basis. I now want the last data flow task of the 4 to run on the 1st day of the month and the others to run daily. Is it possible, to disable this so it runs only on the 1st without me having to open the package on the 1st day of every month to do it manually?
Conditionally execute, yes by changing the precedence constraint (aka green arrow) going to it to include an expression that only evaluates to TRUE on the first day of the month. Then change 'Constraint' to 'Expression and Constraint'.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.