If you are using SQL 2016 or onward version then go for Temporal Tables to maintain the history. This is something new inbuilt feature as far as Audit Log/History...

Like this?

DROP TABLE IF EXISTS #t1;

CREATE TABLE #t1
(
    c1 INT
);

INSERT #t1
(
    c1
)
VALUES
(2  )
,(11)
,(4)
,(9);

SELECT t.c1
      ,c2...

Here's another idea:

In the Execute SQL Task, can we check to see if the parameter has a null value?  If it does, then we can SELECT the max(date).  If...

Parameter values are assigned before the package starts executing and are read only during execution, so what you are asking is not possible.

Yes, that is not a domain account. Does that local account have the necessary rights to create files on local drives?

For the purposes of testing (and don't forget to change...

Here is a grossly inelegant solution that I knocked up quickly. Others will no doubt come up with something nicer to look at!

DROP TABLE IF EXISTS #Names;

CREATE...

Is SSIS dev in 2019 now working OK? I had assumed it would not be roadworthy until sometime next year, based on experience.

It's starting to sound like a software update issue. On a test...

Can you reproduce the error locally?

I suggest that you collect the execution plans for the slow and fast versions and compare them. The comparison should provide clues about what's going on and how to fix...

Please post back when you find out the reason. It's an interesting one.

Sorry Phil.

My questions are:

<li style="list-style-type: none;">

1. Why would I get Load_Dte as local time when run from Desktop and UTC when run from server?

<li style="list-style-type: none;">

1. How...

And your question is ...?

1. Is this a problem?
2. Can I make all times UTC?
3. Isn't this great? I thought you'd all like to know.
4. Do you know why this...

Nothing has changed anywhere

Something has changed, somewhere, or this would not happen. Server o/s update, .NET update, underlying data, permissions, other software installed, ...

Is this a blog post, or do you have a question?