small error on my original code - the temp table was referring an non existing alias (t1)- easy to fix I think.

another attempt at simplifying it assuming that I correctly...

no difference.

your code was only looking for the the friday date on a particular situation e.g. when the EXPIRATION = Thursday

so by determining all the FRIDAY dates in advance, subtracting...

adding further indexes on this case likely not the best - the underlying table is a columnstore table.

the thing that would speed up the most is to have a computed...

a image of the plans don't help much - please post the real explain plan - actual if possible.

use https://www.brentozar.com/pastetheplan/ for it

SSIS has behind the scenes to retrieve the table metadata - this error seems to indicate a mismatch between the server and the client driver - or some parameters need...

this is one of those cases where you do NOT want to use SSIS native dataflow to do the transfer.

<li class="text--left" style="text-align: left;">SSIS Script - using .net sql datareader...

I would not consider it a big issue for now - you can still install prior versions of SSMS and keep using it.

does it work if you try

DECLARE @ids NVARCHAR(max)
select @ids = string_agg(inserted.[lo_location], ',')
from (select X.query('.').value('(row/lo_Location)[1]', 'int') as lo_location
          ...

change your select to include all columns from the commented out join - and uncomment it out as well and order by variant code

then look at the results and see...

what is the aversion at googling before posting? a simple google for "powershell wait" returns you the command you need to use for it.

NVARCHAR is not needed for french characters, neither is a french collation (which does affect ordering but not much more). but SSIS being very picky will require NVARCHAR on destination...

that has to do with what the encoding of the files are, the encoding defined on your SSIS package file definition (and potentially on any transforms you may have on...

Hello and thanks in advance if you can help.

I guess its somewhat acceptable in dimensional modeling to use the INT data type when creating a date dimension surrogate key....

quoting just to keep original text - reporting original due to spam signature links

simple script in Python that can be used to de-identify data by replacing sensitive information with...

it would help if you stated working hours time zone. including core hours for team availability. that may push some not to be interested at all.