Well, I guess I am one more person that did not get the points due to snapshot isolation being on. The question should have specified the state of snapshot isolation....

I had to move on as I needed to make some progress on the ETL but I will try this when I get a chance and post the outcome of...

I agree. Thank you for your input.

Luis

Thanks Da-Zero. So far it seems including the query on the OLE DB data source is the way to do this..

I thought about this other option:

I could omit the join...

In this particular case the sources are multiple tables from different sql servers.

Wow...