The bottom line is that I can only get it to work on this particular machine if I embed the query in a stored procedure that I must store in the source database. This is not a viable option as I am not allowed to create stored procedures in a third-party product database.

Frankly, this whole thing is nonsensical. It works perfectly fine in multiple environments against a slightly smaller (i.e. the test database contains 99% of the same data in the production database) subset of the data but refuses to work in the production environment. It doesn't even give me an error, it just refuses to return any rows in SSIS but will return rows if the query is run independently.

I know I'm preaching to the choir but I really don't have time for this random crap. :crazy: