Search
InstantDoc ID
GO

Browse By: Author | Issue

October 30, 2008 09:30 PM

Integrate MySQL and SQL Server

Use SSIS to retrieve data from a MySQL database and insert it into SQL Server tables
Rating: (0)
Robert Sheldon
SQL Server Magazine
InstantDoc ID #100114
Executive Summary:If you work with SQL Server Integration Services (SSIS), at some point you’ll probably need to access data from a MySQL database and integrate it into Microsoft SQL Server. Here’s an easy-to-follow solution that uses SSIS, Business Intelligence Development Studio, MySQL connectors, and SQL and SQL Server (T-SQL) scripts to retrieve data from two MySQL tables and insert that data into corr...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

Top 8 Considerations for Sizing a Microsoft SQL Server BI Solution
A Tip Guides by Hewlett-Packard
A Jump Start to SQL Server BI
A EBooks by Microsoft
Moving SQL Server to the x64 Platform
A EBooks by AMD
The Essential Guide to SQL Server 2005 BI
A Essential Guides by Dell
More
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.