Exporting MYSQL to MSSQL

[Paul Andrews]

Hi,

We've got a live system that runs a MYSQL server. Periodically we wish to extract relevant data into a MS SQL in order us to run reports etc from another system.

The problem I'm having is that i can happily run a DTS package to extract a full table to another exact match table, however whenever I try and use a SELECT statement to specify the fields it gives me the following error

"Unexpected error returned. An error result was returned without an error message"

Anybody any ideas?

Paul.