I just took a closer look at the code and realize that the insert doesn't specify the column names.

Try adding the list of columns right before the VALUES clause

insert into opendatasource ('SQLNCLI',

'Data Source=REMOTESERVER;USER ID = User; PASSWORD=User')

.server.[M].[tablename]

(Column2, column3, column4, column5) -- Column names in same order as VALUES clause

VALUES ('column2', 'column3' ,GETDATE(),'column5')