I can see why CAST might do that (although I'd expect it to cause an error instead), but...

Make sure you check the options on all pages.  By default the GUI includes a tail log backup.

The GUI - by default - performs a tail-log backup of the existing database when you perform a restore over that existing database.  If you do not uncheck the box...

Yes - you definitely need to be using precedence constraints between tasks.

1. Reads (select) don't block other reads - locks on a select could prevent inserts/updates/deletes on the table(s) but...

First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values.  Are you sure...

This is probably an issue with *how* SQL Server is sending the query to the DB2 instance.  As soon as you use that view - and either join to another...

Thank you for the update - glad this worked for you.

FYI - my approach is to disable the non-clustered indexes and rebuild all indexes after the data loads.  I only...

my other peer ran the query select * from db1.dbo.view1.  which worked and is the query he doesnt want to change in his app.  we arent gurus but in...

In the OLEDB Destination - in SSIS - you control the batch and commit sizes.  If you leave those as default then all of the rows processed through the pipeline...

If all you need is the last 4 from the card number - I would use this:

RIGHT(LEFT(s_Result, CHARINDEX('|', s_Result) - 1)), 4) AS last_four

No need to determine...

thx, what if he puts a surrogate db on the new server called A.   And it has a view that thru the linked server sends the correct query to...

Another option is to take a backup - copy to new server and restore WITH NORECOVERY.  Prior to cutover, perform a DIFFERENTIAL backup, copy the file to the new server...

Just guessing - because you didn't actually provide any information on the issue.  It seems you have a column that IS NOT NULL - but has some type of 'data'...

That is only available in SQL Server 2022 or higher - and the OP is using SQL Server 2016.

The code provided...

One of the reasons a package will be built to look back more than a single day is to cover any days where the package run is missed.  On the...