I don't know what exactly cause this error, but i agree with Craig advice : use INSERT INTO mytable FROM MEMVAR (or update-SQL) which are better way to do this.
HTH