Can you provide some literal sample content for @json, please. For many people, sp_OACreate and other OA modules are blocked for security reasons.

This chunk of C# is sufficiently complex that I doubt anyone here will produce a modified version for you. But I will provide some comments:

1. It seems obvious, but why...

I used to use the Azure SSIS Integration Runtime, but stopped using it because of some limitations (it was expensive too). It was more than a year ago, so I...

This thread is about the SSIS/SSAS/SSRS extensions for VS 2022, not SSDT itself. Those extensions do not yet seem to be available. Eg,...

When I do things like this, I return separate columns for the properties I wish to control (font, bold, colour etc) and then assign those columns to the...

I was half looking forward to giving this a proper go, as I'm sure it would be good for my own PQ education, but it seems that it's probably not...

When I do things like this, I return separate columns for the properties I wish to control (font, bold, colour etc) and then assign those columns to the relevant Tablix...

How does knowing the distance from source allow you to calculate the destination? Wouldn't you also need to know the exact direction?

If you want people to write SQL, please provide...

I see what you mean about the format of that.

Based on that data, I am struggling to find a unique key for the results. You would think something like

PurchasedAt (DateTime),...

Can you confirm that you also ran GACUtil to add the assembly (DLL) to the Global Assembly Cache?

WITH grouped
AS
 (SELECT
      g.id
  ,   g.Game_Time
  ,   Grp = (ROW_NUMBER() OVER (PARTITION BY g.id ORDER BY...

I don't know what these look like. Can you perhaps provide an example?

WHERE (ProductId in (1,2) AND Created_Date < '20220301') OR ProductId NOT IN (1,2)

Welcome.

First of all, this is not a subreddit, but a 'proper' Web site!

SQL Server 2012 is well and truly out of date and IMO you should be learning a later...

Create a variable which contains the entire connection string (not just the file path).

Map that variable to the ServerName property of the connection manager.

At least, that's how I do it.