Thanks, using the UPDATE FROM structure was the answer. So my script now looks like this, and parses successfully:

UPDATE GISADMIN.ServicePoint

SET GISADMIN.ServicePoint.AddressStreetNumber=GISADMIN.ServiceTap.AddressStreetNumber

FROM GISADMIN.ServicePoint

INNER JOIN GISADMIN.ServiceTap

...