Should be doable. Which part of this problem is puzzling you?

1. How do I delete (I would suggest 'archive' as a possible alternative to deletion) a file?
2. How do I...

Not sure whether I know how to debug C# 'correctly', but this is how I do it.

1. Edit the code in the Script Task and put a breakpoint near the...

In order for SSIS to find the Newtonsoft assembly when the package runs, you need the following two things to be in place:

1. The assembly to be in the GAC...

Sure, take a look here.

Have you added the Newtonsoft DLL to the GAC?

Good summary.

A quick note about SSDT for VS2022 – as far as I know, there is not yet any support for extensions which support SSIS (or SSAS/SSRS). It will probably...

ABS is not an aggregate function & that is your problem, I think. If you changed that to

SUM(ABS(b.HistoryQuantity - a.TOTFCST))

it might resolve your issue.

By "separate fields", do you mean in separate columns? No, that is not...

Replace the SELECT ', ' row of my code with this.

SELECT CONCAT(', ', q.Test, ' - ', q.Value)

Following the same logic, you should easily be able to...

• This reply was modified 4 years, 1 months ago by Phil Parkin.

If this was 2017, I'd use STRING_AGG() to do this, but as we're in a 2016 forum, FOR XML PATH will have to do:

SELECT p.ContainerID
  ...

Not much consolation, but it's always been like that: VS comes out first, followed, often many months later, by the SS*S development toolset.

I suggest you revert to VS2019 for now,...

I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

One of our Devs has a question. He's trying to get...

SELECT base_object_name
      ,DBName = PARSENAME(base_object_name, 3)
      ,SchemaName = PARSENAME(base_object_name, 2)
      ,ObjectName =...

Sure. Something like this (untested) should do it:

            for (int i = 1; i <= 632;...

Please explain why it's "not really the solution".