Try this:
INSERT INTO MYSQL.dbo.traffic(id,date,time,ip,resultCode,bytes,url,authuser,sitesID,usersId)
SELECT t1.id,t1.date,t1.time,t1.ip,t1.resultCode,t1.bytes,t1.url,t1.authuser,t1.sitesID,t1.usersID FROM
OPENQUERY(MYSQL, 'SELECT * FROM mysar.traffic') T1
LEFT OUTER JOIN MYSQL.DBO.traffic T2
ON T1.id = T2.id
WHERE T1.id IS NULL