| Author |
 Topic  |
|
|
Architect
Starting Member
8 Posts |
 Posted - 02/28/2008 : 17:14:48
|
I need to pull data out of SQL Server 2005 and load it into a MySql 5 database, and can't find a way to do this efficiently in SSIS since there's no ODBC destination, and I couldn't find an Oledb driver for MySQL. Any thoughts on the best way to accomplish this, aside from exporting to text, and then loading it into MySql via the mysql client or mysql importer?
-A |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 02/28/2008 : 18:18:00
|
If you install whatever driver mysql 5 uses onto the SQL Server, then you'll have that driver available in SSIS.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/ |
 |
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
|
|
rmiao
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 03/01/2008 : 22:34:10
|
| You can download MySql odbc driver from MySql site. |
|
|
|
Architect
Starting Member
8 Posts |
Posted - 03/03/2008 : 23:29:56
|
| The ODBC driver doesn't solve the issue since SSIS only supports OLEDB destinations. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 03/03/2008 : 23:36:47
|
quote:
Originally posted by Architect
The ODBC driver doesn't solve the issue since SSIS only supports OLEDB destinations.
Since when?
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 03/03/2008 : 23:38:47
|
| Microsoft has ole db provider for odbc driver by the way. |
|
|
|
opc.three
Starting Member
USA
5 Posts |
Posted - 06/29/2012 : 15:57:45
|
quote:
Originally posted by tkizer
quote:
Originally posted by Architect
The ODBC driver doesn't solve the issue since SSIS only supports OLEDB destinations.
Since when?
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
I know I am grave-digging on this thread but this is a top result on Google when looking for info on loading data into MySQL using SSIS 2005 so I wanted to update the thread.
Architect is correct. In SSIS 2005, which the OP is using, we do not have a true "ODBC Destination" component.
In SSIS 2008 we can load data using ODBC, however only via the "ADO NET Destination".
It was not until SSIS 2012 was delivered earlier this year that we gained native access to ODBC as a destination: http://msdn.microsoft.com/en-us/library/hh758691%28v.11.0%29.aspx
Make everything as simple as possible, but not simpler. -- Albert Einstein |
|
|
|
opc.three
Starting Member
USA
5 Posts |
Posted - 06/29/2012 : 16:01:18
|
quote:
Originally posted by rmiao
Microsoft has ole db provider for odbc driver by the way.
MSDASQL was deprecated before SQL Server 2005 was released and never worked with SSIS 2005.
Make everything as simple as possible, but not simpler. -- Albert Einstein |
|
|
| |
Topic |
|
SQL Server 2K5 to MySQL 5
