Solved

Creating ADO Connection in SQL Server SSIS for MySQL

Posted on 2008-06-20
2
358 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
Comment Utility
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

12 Experts available now in Live!

Get 1:1 Help Now