What's the source? What kind of data source are you getting the data from? Can you specify on the select to convert that datetime column to varchar instead? You just have to find which column is offending the t-sql and you also need to enumerate the column names on your select not just "*".
-- CK
Hi
The source is a Progress database.
I've spoken to a colleague in the office and he suggested using a cursor to find the error, however when this employed, it returns a huge error message relating to various columns within the Progress database.
The error may be appearing because the Progress database (via the linked server) uses a different datestamp to SQL Server or because there is a problem with the link between the Progress database and SQL Server.
Not to worry. Thanks for your help.