MySQL Forums
Forum List  »  Microsoft SQL Server

Exporting MYSQL to MSSQL
Posted by: Paul Andrews
Date: September 05, 2005 06:20AM


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?


Options: ReplyQuote

Written By
Exporting MYSQL to MSSQL
September 05, 2005 06:20AM
October 31, 2005 11:37AM
November 21, 2005 09:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.