I guess that could help with troubleshooting.

h.refID varchar(50)

s.DistributorOrd varchar(50)

WHERE s.DistributorOrderNumber is null should be ...DistributorOrd... still not working

the information is initially imported from the h. table into the s....

As bwillsie put it, I am always leery of CU cherry picking because I am concerned that something is missing. On another note, to choose the correct CU, you...

Nicholas - yes SSIS is using WinAuth for connections

The_SQL_DBA - ran the script on both DBs and no change in error.

Yes, both databases are owned by 'sa'