Is the version of SQL Server the same on the local machine and the server?

Can the column in the source table ever be null?

DECLARE @sql VARCHAR(MAX);

SELECT @sql
    = STRING_AGG (
                 ...

This still sounds like an ASP.NET question. Why do you think that this is a SQL Server problem?

thanks phil, do you mean all on the same single pc?   That's the kind of feedback i was hoping for.   That way no one instance of sql could interfere...

Have you considered using multiple local VMs, one per project?

Not sure what your question is, please elucidate.

This is exactly what I was thinking, too.

What do you mean by the 'SSISDB category'?

What does the package do? Is there any file system interaction?

If you open the All Executions report for the package, does that provide any clues as to the issue?

I've not used geography:, but perhaps this post is a similar issue?

https://stackoverflow.com/questions/40558663/spatial-query-a-net-framework-error-occurred-during-execution-of-user-defined

At no point did I suggest that Jonathan's code...

Maybe the application settings for SQL within the Application is different than what I'm running in SSMS

That was my first thought. You should check this.

There must be a more elegant way of doing this, but I ran out of time. This appears to work with the existing data:

WITH filtered
AS (SELECT p1.Code
...

Looks promising, but I haven't used it.

You need to start doing some R&D.

Once you figure out how to code the REST calls you need, whacking that code into SSIS isn't...