Here is the plan:

-log into SFTP server and download files to local directory

-unzip files to specified folder

-import files into SQL Server table (it will always be the same table)

-if...

how to handle features or  columns that i don't know it

suppose i add new feature today and every feature have column

then every feature added will modify on code

if you...

First Create your query as a VIEW:

CREATE VIEW dbo.QRY_DATES AS

SELECT ...

Once the view is in place, you can reference it from other queries.

So every time the file appears, it has a slightly different name? As long as there is only one file in the folder at any one time, this is not...

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 3 years, 11 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,...