Solved

Creating ADO Connection in SQL Server SSIS for MySQL

Posted on 2008-06-20
2
361 Views
Last Modified: 2008-12-31
I'm currently having trouble creating an ADO connection in an MS SQL Server 2005 SSIS package. I need to run an 'Execute SQL Task' in the package. The connection is a MySQL server.

What drivers/software do I need for the ADO connection for MySQL?

Is there any other trick or anything I have to do differently with the SQL for a MySQL database table/query versus a MS SQL Server table/query?

Thanks!
0
Comment
Question by:arccos
2 Comments
 
LVL 8

Accepted Solution

by:
sbagireddi earned 250 total points
ID: 21835333
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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