Hi,

I had the same error message popping up after a few rows being retrieved from the linked server. The same query when ran on a different data set, was working fine without any errors. Then I started some research and came to know that, it was a data related issue.

In my scenario, the select statement was having a case condition which was failing to validate.

Thanks

Kranthi