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 4 years, 3 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...

Yeah, Des, there's really no GOOD way to map the view's columns.   After all, the purpose of a view is often to obfuscate the existence of the table for security...

There's quite likely a difference between the two packages...  I'd examine both dtsx packages with a file comparison tool and see what is different.   There are ways to tune a...

Not really...   again, I'm not talking about changing the connection manager's file path.  That's already coming from a package variable.   I'm talking about dynamically changing which connection manager a Flat...

• This reply was modified 4 years, 4 months ago by  sgmunson. Reason: spelling

I hate to venture a guess, but while I'm just as curious as to what the original poster meant with the extraordinarily vague wording provided, I just can't help wondering...

Well, ... there's still no response from the original poster with an execution plan...

So, while we can all speculate as to what's going on, and ponder on what the value...