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.

Same version of SQL Server on both machines?

Untested, but I think this is tidier. Converting date to VARCHAR is going to hit performance. Also, I suggest that you never use VARCHAR without specifying its length. Under some...

Your description is hard to understand.

Please provide DDL, sample data as INSERT scripts and desired results based on that sample data, and it will be easier for someone to provide...

Referencing assemblies using NUGET does not work in SSIS script tasks. Instead, you need to register the assembly in the global assembly cache.

Please read the following page and see whether...

sp_send_dbmail (link) will send an e-mail for you. But you still have not asked a question. Sample questions:

• How do I send an e-mail in T-SQL?
• How do I...

• This reply was modified 3 years, 8 months ago by Phil Parkin. Reason: Fix typo

WinSCP can be called from an SSIS C# task (link).

We can't debug a large chunk of C# code for you. Especially if you do not tell us what errors...