Solved

Creating ADO Connection in SQL Server SSIS for MySQL

Posted on 2008-06-20
2
359 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now