Bolting them all together at the end sounds clean enough to me – also makes it easier to maintain when things change (adding or removing files, changing file order etc)

I don't know the answer.

But keeping the compatibility level unchanged does not imply that the CHECKDB process will also be unchanged. Perhaps the checks have become more thorough and therefore...

Is this the sort of thing you are after?

--Set up test data
DROP TABLE IF EXISTS #CatTable;

CREATE TABLE #CatTable (Id INT, Category INT, CategoryDate DATE);

INSERT #CatTable (Id, Category,...

I've decided to get back to using week, which treats week 1 of 2021 as a week with one working day only, like it should be

So are you stating that the...

How to put this information in a single row showing id,firstname,lastname, address1,postcode1,address2,postcode2,email1,email2,First Family(flag), Second family(x)? If there is no second address it should show just one address.

What do First Family(flag)...

Are you talking about modifying the existing data, or adding new rows of data, to achieve this? Out of interest, can you explain why you would want to do this?

Either...

OK, try this (I used a temp table, so you need to rename #vehicles accordingly)

SELECT
    model
,   engine_size
,   MN.model_cnt
,  ...

I'm not familiar with Query Builder. Can it use temp tables or subqueries?

I can probably help. But you need to help explain, in English, how your desired results are to be obtained.

In your sample data, for example, the FIESTA has multiple engine...

For the FIESTA, your desired engine size is 1.7. Please define the grouping logic you wish to apply which selects 1.7 rather than any of the other FIESTA engine sizes.

AlphaTangoWhiskey:

Thanks for your help. I don't think the account being used for any proxy or the SQL Server agent will be used when I'm running the package from Visual...

Instead of creating views - you can use synonyms.

This gets my vote too.

Doesn't matter – search for both.

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData (LongString VARCHAR(8000));

INSERT #SomeData (LongString)
VALUES
('dlfkjh...

So the string will contain either

"IsFso":true

or

"IsFso":false

Is that correct?

Sounds like the package file XML may be corrupt.

Are you able to completely delete and recreate the connection?

If not, it may be a good idea to start afresh with a...