Solved

DTS & MYSQL

Posted on 2006-11-06
5
569 Views
Last Modified: 2013-11-30
Hello,
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.

Thanx

Steve
0
Comment
Question by:SteveH3897
5 Comments
 
LVL 11

Expert Comment

by:rw3admin
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]

0
 

Author Comment

by:SteveH3897
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?

Thanx

Steve
0
 
LVL 3

Expert Comment

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

Expert Comment

by:rw3admin
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]
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 250 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.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

789 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