Thank you Phil, I think that will work when I do deploy to the SSISDB.

At the moment, dataverse is constantly being update with a new/deleted/updated columns which is why...

You are correct, my apologies!

You can avoid all parallelism by using the Sequence command in your JSON and setting maxParallelism to 1.

https://learn.microsoft.com/en-us/analysis-services/tmsl/sequence-command-tmsl?view=asallproducts-allversions

Default, Full, Clear and Recalc are the options I'm seeing on the 2017 Standard Edition I have immediate access to.

Assuming you have deployed to SSISDB ...

Use an environment in SSISDB and create a sensitive parameter to contain the secret value.

Configure your SSISDB project to reference the environment and then...

You may find this article an interesting read … it is relevant to your question. Not that it solves anything!

https://www.sqlservercentral.com/articles/antipathy-for-entity-attribute-value-data-models

Based on your description, it sounds like you may already...

Are you able to provide more details about this issue? I know...

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    SomeId INT IDENTITY(1, 1)
   ,SomeText VARCHAR(10)
   ,CONSTRAINT PK_Nonsense
     ...

Is it so difficult for you to ask a question?

Can anyone provide the T-SQL code I need to amend an identity column from INT to BIGINT, please?

I am guessing that...

That message usually appears when you haven't installed

Microsoft.DataTools.IntegrationServices.exe

after installing VS. However, as this worked for you after updating VS, I'm not sure what's going wrong now.

What is your question?

After restoring your 2019 backup, you could try running this tool to get the rest of your data moved back:

https://www.devart.com/dbforge/sql/datacompare/

This is not a recommendation, just a possibility. I have...

You can get SSMS to do all of the table-by-table scripting for you, no need for any dread!

https://stackoverflow.com/questions/77508309/how-to-process-full-tables-in-tabular-ssas-cube-using-xmla-file

Linked Server is the specific term you are looking for, I think. Take a look at this link, for example:

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver16

The error relates to memory (ie, RAM) not disk space. If you Google your error, you will see that people have come up with various ways of addressing it (get...