SSIS and determining Day-Of-Week and branching if "Monday"

Question

I want to evaluate the Day-Of-The-Week and then branch to an Execute SQL Task that will derive my @GloabalStartDate and GlobalEndDate Variables to set Friday thru Sunday if the Day-Of-The-Week is determined to be "Monday".

Can someone share how I do this? Do I have to derive the Day-Of-The-Week first with an Execute SQL Task...

SELECT DATENAME(WEEKDAY, GETDATE()) AS [DayOfWeek]

Result Set that to User::DayOfWeek

And then create an Expression Task to Evaluate it?

I tried just using a constraint but it doesn't seem to like...

Answer 1

Hi BobbyP,

May I know how do you configure the tasks in your ssis package?

We can use the following expressions in the Precedence Constraints.
Expression 1: DATEPART("weekday", GETDATE() )==2
Expression 2: DATEPART("weekday", GETDATE() )!=2

Please refer to the link and the pictures below:
Using Expressions On Precedence Constraints in Integration Services

Best Regards,
Mona

----------

If the response is helpful, please click "Accept Answer" and upvote it.