Phil... thanks for that as actually it is copying the table and keeping the same name with _new added.  So for the mis hap..will correct my self in the...

Work out the syntax for renaming a single table and then write some T-SQL which queries sys.tables & constructs that T-SQL for all tables, as a SELECT.

You can then cut...

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...