Check the table you are trying to insert data into. I would guess it is a SMALLDATETIME type that is causing the problems. Change all SMALLDATETIME to DATETIME and try the...
You will need to create a new linked server and hit the "Provider Options" box, I enable ALL options -- I am not completely certain what they all specifically do...