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

That is a requirement. But what is your question?

Try this:

CASE WHEN LEFT(t.DC,2) IN ('01', '02', '08', '21', '22', '30', '32', '40', '55', '62') 
THEN LEFT(t.DC,2) 
ELSE '01' 
END AS DC

--deleted

• This reply was modified 3 years, 6 months ago by Phil Parkin.

That's a bit trickier, but try this version and see whether it helps:

WITH ordered
AS
 (SELECT
      hs.Id
  ,   hs.SalesID
 ...

Your trigger will fail if more than one row is inserted or updated in a batch, so I suggest that you fix that.

What do you want TitleNormal to be updated...

Here's an example

DECLARE @Query VARCHAR(1000) = 'SELECT TOP (10) object_id, name FROM sys.columns';

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab
(
    object_id INT
   ,name...

Does this help? It uses the ROW_NUMBER function to perform the ordering and partitioning that you need.

DROP TABLE IF EXISTS #HectorSales;

CREATE TABLE #HectorSales
(
    Id...

• This reply was modified 3 years, 6 months ago by Phil Parkin. Reason: Improved code. Removed unnecessary CASTs and changed Unicode literals to varchars

The logical equivalent of

NOT (A AND B)

is

NOT A OR NOT B

so changing the AND in your query to...

It doesn't work the way you are hoping (ie, with some sort of table-name cursor).

If you write a query in that window, it will export the results of running that...

As this is specialised software, perhaps you should get support from the vendor?

One possibility is the use of SYNONYMs to help you in this.

Assume that the synonyms 'point' to tables in DB1 on day 1.

On day 2, DB2 is updated. If...