I've not yet moved from SQL 2012 to 2019 but in previous database upgrades the SSIS packages have to be rewritten or at least recompiled in Visual Studio.

I'm interested to...

" it returns a null value which ado.net doesnt like"

Really!, there is a database driver that doesn't handle nulls?!

You should check the which index, on the table that has this column, is being used (from the execution plan), then add the column you have added to the INCLUDE...

The first thing you should do it look at differences in the execution plans.

Did you just add the column to the rows that are being selected and not add it...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys:...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2 for not...

Yes, that's what you need to ask for.

Tava,

Can you supply some more details of the processing involved?

SELECT RIGHT('00000000000000' + convert(varchar,@qtramt1),14)

If you have integers or other number types you might need to convert them to varchar first or they will get converted to zero.

Just noticed this when I was putting this on a new instance, but in the .sql file the WITH starts with a leading ;, which actually breaks the DDL...

;with cte as 
(
    select ROW_NUMBER() OVER (ORDER BY x.dateofreading) RowNum,
           *
  ...

delete x
  from @staging_account x
 where not exists(select *
                 ...