We are migrating from a MySQL database to a SQL Server 2005 database. There are about 50+ tables in the MySQl DB. I am trying to use SSIS on the SQL Server 2005 server to migrate the tables from MySql to SQL Server 2005. I recently added a new MySQL system DSN ODBC on the SQL SErver 2005 Windows system. When I run the Import/Export tool on the SQL Server 2005 server the new system DSN is not ilsted as a choice of data sources. Here is the procedure I am using
1) SQL Server Manager Studio
2) Connect to a Database Engine
3) Expand Databases
4) Right-Click the DB I want to import to -> Tasks -> Import Data
5) This is where the problem is. The newly added MYSQL data source is not listed to select. I have rebooted since installing the DS. It is configured correctly because it verifies during the test.
Please, any ideas on resolving this issue are greatly appreciated.