My issue seems to be a bit different than Andy's, but the results are the same... I am not getting all of the data from certain tables, which is strange. Some tables I get all my data from okay, and other I do not, and I am not sure why this is.

I am pulling my data from an Oracle db using the connection that DW sets up. When I right click on certain tables, I get a very small bit of the data in those tables. For other tables I get the whole enchilida. What would be causing this difference?

With me, it all shows in the Test feature on the recordset box, but noton the page...a little different to yours. Have u got the XP SP2 fixer in place on DW? I can be known to make tables look enpty when they are not. I know this isn't your exact problem...but you never know...