I don't have permission. It's a third party real estate database that gives users the ability to query certain views that they have created for developers. They don't...

Unfortunately I don't have permissions to do anything but select from the remote server.

Even if I change the destination field to match, I'm still getting the error. I think the error is saying that the results returned from the query don't match...