The error I got was very similar. I was trying to do the following update and "push" the data across to a linked server:

update ServerName.AAD.dbo.t_employee

set ServerName.AAD.dbo.t_employee.work_shift...