you were clear - but you did NOT show us the code where you are trying to concatenate the fields - without that we can't tell you what you did...

you didn't really post your code here neither the error you got - but look at function datefromparts which will allow you to do that easily.

for info - kind of only found out recently why I still have the debug menu available.

I use SQL Complete PRO from Devart - this product adds the debug option...

can you give us the output of these queries

select @@version

select cpu_count
     , hyperthread_ratio
     , physical_memory_kb
    ...

on your command line you are using to create the .7z files you just add the extra parameter to 7z

MAX DOP should also be changed as well as CTFP value as they likely on default (0 and 5 respectively)

DOP depends on how many CPU's you have - CTFP I...

SQL Server Agent job account needs access to the share/file - that is where it is failing now.

Or the Proxy account used to run SSIS packages if you defined one...

its documented even if not clear for some.

https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16

| derived_table [ [ AS ] table_alias ] [ ( column_alias [ ,...n ] ) ]

syscat is DB2

you need to get another admin to do it - or you setup a SQL agent job to delete it for you (but will need to kill all sessions with...

and using a sql agent proxy (can be per defined 1 per job) is in a way better than using the xp_cmdshell proxy (system wide).

on a multi-tenant server using the...

if you have to ask you likely don't need it - and I have to say that there is huge amount of info on the net so you asking here...

big transaction that required more space to be allocated - when it failed it did a rollback so space is there now - but wasn't when the transaction was running...

can you give the full command line - change servername and package to something else but meaningful - this so we can see exactly which parms /options you passing to...

One more question though. When we assign primary key to a column it creates clustered index by default on that column but I know that in future I will...