Didn't know much about what the loop was doing--you didn't say. 🙂 My thought was that if it was hitting different servers with a dynamic connection string, it could be permissions on the server hit during that iteration. The other thought was that if it was hitting different tables, views or whatever, it might be permissions on the particular object for that iteration. If it's the same tables on the same server, it's probably not permissions. What I've found on the occasions where I've gotten this message is that each time it did turn out to be a permissions issue--sometimes when I was sure it wasn't. But it's hard to see how that's the case here if it's the same server and db objects each loop.

I don't know of any limitation on the number of iterations.

[Edit to add a question] Does it stop at the same iteration each time?