Just an fyi, but this problem was the why behind two other posts, as I had been thinking that the only way to make the Execute SQL Task work with...

For the solution to this, see the following post:

https://www.sqlservercentral.com/forums/topic/ssis-expression-task-does-it-even-work

I spent a LOT of time searching online and struggled mightily to overcome the errors introduced by just one misinterpretation of...

Glad it was helpful, homebrew...  It was a real bear of a problem, and very difficult to find the information online that was needed to quickly solve it.   Only rarely...

okay folks, here was the entire issue:

1.) I had misinterpreted some of what I saw online, and ended up setting the property "ExecValueVariable" to the variable I had wanted to...

Well folks, this one sure was interesting....  it now appears that setting the ExecValueVariable to anything other than "<none>" causes it to fail, although it may be that setting it...

• This reply was modified 5 years, 2 months ago by sgmunson. Reason: Adding a picture for additional clarity

SPAM?  Is it not okay to have links to business pursuits?

Okay, one last question - realized just now that the "next occurrence" could potentially be in the past, so can I safely assume that it's the next occurrence that is...

Well, had to just give up and not use variables  for what I had wanted to do.   Just used raw data instead within the Execute SQL Task items, and instead...

Okay, let's get some terminology straight...  Your example data has no condition where the dayValue column minus 5, does not equal the default weekday value that SQL Server could compute...

• This reply was modified 5 years, 2 months ago by sgmunson. Reason: Additional info that might be of value

Yeah, I expected as much...  gee thanks Microsoft!   Anyway, I finally decided to try and "outsmart" SSIS and just let the NULL values hang out in the query statement, following...

Icthyosaurus / Ottoman / Centipede / Octacore / Hexagonal / Pentameter / Quadratic / Triage / Duo / Unify

If you need a good SQL consultant and are willing to do so "off hours" for the Eastern Time Zone of the USA, then I'm available at a much more...

That's what I assumed it meant. Other interpretations didn't make sense. I suppose writing the table name and column name to at least a temporary table and then using...

Take a look at the Scripting.FileSystemObject in VB. I used that in an SSIS package to check the date/time stamp for an xls file before importing,  you should be...

Okay... finally, the package has to handle one and only one file.   Unless I can see a way around the Flat File Source having it's connection manager changed, I have...