SteveH3897
asked on
DTS & MYSQL
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
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
ASKER
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
Thanx
Steve
try using "other(ODBC Data Source)" as the data source for the MYSQL server connection
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]
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]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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]