Posted on 2006-11-06
Medium Priority
Last Modified: 2013-11-30
Is there any way of using a MYSQL data source and then import that data into MSSQL via a DTS package.

I've tried to configure DTS to a MYSQL source - but it won't let me select a particular source.
At the moment I have a linked server from MSSQL to MYSQL so that I can see the various dataoutputs from MYSQL.

Any help is greatly appreciated.


Question by:SteveH3897
LVL 11

Expert Comment

ID: 17884658
not too sure but can you create an ODBC connection to MySQL and then create a Connection in DTS and use this ODBC for connection?
you said you have MYSQL source as a linked server, you can always reference data from this link as well, as
select * from [mysqllink]..[tablename]


Author Comment

ID: 17884700
I've already configured an ODBC connection - and part of the problem is that on yhe MYSQL box there are several data outputs but DTS won't allow me to see them?



Expert Comment

ID: 17884993
try using "other(ODBC Data Source)" as the data source for the MYSQL server connection
LVL 11

Expert Comment

ID: 17885293
yep under connection on DTS design wizard use option number 11,
have you tried other approach also go and create a DB connection to the server where you have MYSQL as linked server and then select "Execute SQL Task" based on this connection and do following to see if you can connect to MySQL from DTS using linked server
select * from [mysqllink]..[tablename]
LVL 30

Accepted Solution

nmcdermaid earned 1000 total points
ID: 17886312
>> I've already configured an ODBC connection - and part of the problem is that on yhe MYSQL box there are several data outputs

You need to create the ODBC data source on the server that is running the DTS package. It sounds like you have created an ODBC connection on the MySQL Server. Are you also running the DTS on the MySQL Server?

If you are running the DTS on a different server then you need to install the MySQL client libraries on that server. That will allow you to create the ODBC entry on that server.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question