I suppose I should also point out that this problem originally surfaced in a much more complex query in which the sub-query was a call to a remote server. ...

UPDATE

I now do and don't know what is causing the above issue. Basically the package runs ok providing the tables the query is based upon are in the same...