Import from Linux MySql

Has anyone ever imported data from a MySql database on a linux server?
I know almost nothing about Linux so I have no idea how to get started
accessing the database with SQL from my SQL Server in order to do an import.Hi
Install a MySQL ODBC/OLE DB driver on your Windows Server.
Then use DTS like normal, but your source is the MySQL database (driver is
the driver you installed) and your destination is your SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Florida" <noneavailable@.hotmail.com> wrote in message
news:%23PwNOHgyFHA.460@.TK2MSFTNGP15.phx.gbl...
> Has anyone ever imported data from a MySql database on a linux server?
> I know almost nothing about Linux so I have no idea how to get started
> accessing the database with SQL from my SQL Server in order to do an
> import.
>

Import Data from Oracle9i DB

I hope this is the correct forum to be posting this in but,

we have a database setup on a linux box that we are trying to get rid of and replace w/ sql server 2005 once we have the data off that machine. The problem that we are running into when we try and import data from that machine is, we get the following message during the DTS import / export wizard:

'Error Source: Microsoft OLE DB Provider for ODBC Drivers'
'Error Description: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist'
'Context: Error calling OpenRowset on the provider'

Hopefully this is just a silly mistake on my end but I have been searching around and have not been finding anything too helpful.

does anyone have any advice?

thank you very much in advanceMoving to the SQL Server Integration Services forum.|||

Please note that ODBC via OleDB is not supported. To use any ODBC driver in SSIS, ADO.NET-ODBC bridge should be used.

One exception to this is the Execute SQL Task in the control flow, which has native ODBC support. Apart from that, to use ODBC directly, the option of using the extensibility model, either with a script component or custom component is available as well.