SSIS OLE DB source missing records in SQL Server 2005 SP2

Issue: I found out recently that a SSIS package I was developing was missing random records/rows when extracting data from a complex database view from SQL Server 2005 SP3. I was using the "table or view" data access mode and picking the view from the dropdown list.

Solution/Workaround: After troubleshooting and verifying that nothing was interfering with the extraction (i.e. anti-virus software, etc.), I found a workaround by changing the data access mode to "SQL command" and just typing "select * from " instead. I am pretty sure this is a bug with SSIS, but I don't know if it is caused by my use of common table expressions and linked server in the database view.