DSXchange

Different files and then use a job parameter to bring in the right one.

Perhaps something similar could be done but the problem here is with time conversion only, there's no date or timestamp involved.

No, because by then your temp table would be gone. You would need to create and popuplate it 'before sql' and then join to it right then. Does this really need to be a true temp table? Perhaps you could persist the table and then drop it after job if all goes well.

Good Lord, have some patience. You posted in the middle of the night for a crap ton of people.

And you actually have a job parameter defined in the job named '$username' - all lower-case, just like that?

The user 'scott' doesn't have the grants that stage needs to operate, grants which are well documented.

And there's only one underscore in the log table's name.

Easy enough to check.

Take the error message after "COMM" and do an exact search for it here.

So, this time they weren't run manually? Meaning, this error only happens when the job is scheduled?

Tell us what you mean by 'updated'? Compared to what?

I'm afraid he does mind.

Where are you trying to do this? Meaning, what stage? You may need to use DateFromDaysSince() instead.

There's a resolution posted here and in other threads if you do an exact seach for that message.