Ran a few more tests on my 2016 dev box.

First query without rollback
Second query with rollback and actual plan

WITH GO between SET and BEGIN TRAN

I ran the script several times my dev 2016 box and every time both estimated and actual plans show 5.

I did this once

Execute SQL Task to create global temp table
Data Flow Task
…....OLE DB Source
…….OLE DB Destination for the output temp table (make sure you set ValidateExternalMetaData...

Or add a single apostrophe to the beginning of the four zeros

First add qty_on_hand for rows where lot will change and the new lot already exists, eg

UPDATE b
SET  b.qty_on_hand += a.qty_on_hand
FROM lot_loc_mst a
 JOIN lot_loc_mst b
  ON b.whse = a.whse AND...

+1

I used to do similar things in...

Make sure you have the correct SSDT for Visual Studio 2017 installed
Only the correct version will work all others either did not work or were broken
MS screwed up...