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

When you execute a proc in SQL Server, there must be a SQL Server login associated with that execution.

There should also be database-level users associated with the login and those...

It sounds like a permissions problem. When the Python script executes, what is its user context and does this user have the permissions required on MSDB?

Can you try executing the...

Does the update work OK when executed from Python? That is, is the only problem with the mail send part?

It should be.

Is there any easy way to :

Search Stored Procedures for a string (I can do this ok)

If say 10 are returned, just click on each one and  go into...

Click the New button and create the connection to the file. Then go ahead and use that.

I've never used avro files before, so cannot help with specifics.

Like this?

DECLARE @List VARCHAR(50) = 'item1,item2,item3';

SELECT
    @List
,   NewVersion = CONCAT('(', '''', REPLACE(@List, ',', ''','''), '''', ')');