Thanks for the advice Phil, Weissa and Dimitris. I'll initially try amending the connection to use the ODBC drivers (easiest solution!!!) and see where I do with that.

The DTS task was created using a wizard and uses the OLE DB connection rather than ODBC.

Many thanks, I'll give BCP a try....