Changing the .NET app so that it only loads the data which is required is not possible, I presume?

You'll probably get more help with this problem if you attach the actual execution plan.

Run this code:

DROP TABLE IF EXISTS #sample_node;

CREATE TABLE #sample_node
(
    id INT
   ,label VARCHAR(10)
   ,realdate DATETIME
   ,datedif INT
);

INSERT #sample_node
(
...

I always forget about updating the CTE directly. Here is a better version:

WITH calcs
AS (SELECT id
          ,label
 ...

Something like this?

WITH calcs
AS (SELECT id
          ,label
  ,realdate
         ...

If you have five columns in a table and the only PK which 'works' is a combination of all five columns, there can be no updates to the data.

Why not?...

This could also be done in Posh.

Have a go and see how you get on. Feel free to post back ... if you cannot get this working, I will put...

I know nothing about this specific problem.

But adding a Script Task to edit and save the file before onward processing should be straightforward. Can you write a little C#?

Why not try and...

Is it make any difference? These are just statistics about servers collected in diagnostic peruses. For example drive space utilization. Currently I collect that at each server separately. I...

I just checked the solution using TOKEN and my solution is almost a mirror of Jeffrey's:

left(token( @[User::strDate],".",3),4) + "-" + token( @[User::strDate] , ".", 2) + "-"...

Metadata, rather than actual data? What sort of metadata?

Are you truncating the target tables first? If not, how are you avoiding duplicates?

Might be simpler to perform a backup/ restore - have you considered that?

Are the packages being executed with a logging level of 'NONE', perhaps?

Another option to try is to setup local configs with the pw and see if that works. From the Parms screen click the "Add Parameters to Configuration" button and...