Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » ADO.Net   (RSS)
Monday, March 02, 2009 10:45 AM

How do I do UPDATE and DELETE if I don’t have an OLEDB provider?

A comment on my post about writing to a MySQL database inspired me to put together this post about how to perform UPDATEs and DELETEs in an SSIS package. The common approach is to use the OLEDB Command transform to execute the SQL statement on a row by
Posted by mmasson | 0 Comments
Filed under:
Monday, March 03, 2008 10:23 PM

Connecting to MySQL from SSIS

Update: See this follow-up post on writing data to MySQL . I've recently seen a bunch of questions about connecting to MySQL from SSIS, so I thought I'd give it a try. Our connectivity wiki currently doesn't have anything about MySQL on it, but I'll try
Posted by mmasson | 9 Comments
Filed under: ,
 
Page view tracker