I just looked up the error on MSDN, but the recommendation doesn't really help ("Remove the remote table column of DBTYPE_DATE data type from the query select list or predicate list." link: http://msdn.microsoft.com/en-us/library/aa226403(SQL.80).aspx)

On a different forum the usage of OPENQUERY is recommended (seemed to work for oracle).

http://groups.google.de/group/microsoft.public.sqlserver.connect/browse_frm/thread/7511b626120f6b48

http://groups.google.de/group/microsoft.public.sqlserver.odbc/browse_frm/thread/c8a3123ae2a4cc1f/98b39d5c04687ea3

To me it looks more like the root cause is an out-of-range date value in the source table (e.g. typo). But that's just guessing... You could narrow it down by run a query against the source table with ISDATE() for col1 through col6 to figure out which values cannot be converted.

Looking deeper into that last step if it's still required or if it can be eliminated is a totally different story...