Thanks Jeffrey, I'd forgotten that CONCAT_WS() even existed.

Is this the extension which you are trying to add?

https://learn.microsoft.com/en-us/sql/ssdt/release-notes-ssdt-2019?view=sql-server-ver16

SELECT CONCAT(Col1,';',Col2,';',etc etc)

Simple and clear, quite impressive. Thanks for posting back.

If you believe this to be a valid and comprehensive response to my request,...

I think I'd switch the logic around a bit.

1. Does filename exist in table2?

   1. Yes – throw an error
   2. Else continue

2. Truncate staging table
3. Import filename to staging table
4. Execute...

Please be more specific than 'it doesn't work'.

We don't have access to your data, nor do we understand the underlying logic behind your query.

If you can provide some sample data,...

Time for me to check this out. As usual, there was an age between the release of VS2022 and its SSIS extension.

Or maybe not! It's still in preview and looks...

Your post raises some interesting points.

I can only take the senders word for it.

I wouldn't, but your way leads to an easier life!

Would you be prepared to share the code...

The FORMAT() function performs notoriously poorly. If you are processing a lot of data, I suggest you remove it and find another way (either in code, or using Excel or...

It may be an integer-division issue.

Try multiplying by 100.0 first, to force a decimal calculation:

Successful Picks * 100.0 / Total Picks

Note also that you have misspelled 'successful'.

I assume no one is suggesting that the act of sending this file is adding those characters?

You should be able to prove that the file structure has changed by using...

Also, why not just use

ORDER BY BusinessEntityID, OrderDate

?

It might perform better.

Define 'properly'. It looks OK to me, unless you want to sort on the name of the month, rather than its ordinal.

Having a single, multifunctional behemoth package is generally regarded as bad practice. Better to add five execute package tasks to your master package rather than copy everything in.

If these child...