Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » ADO.Net   (RSS)
Thursday, November 12, 2009 11:29 AM

Something new for SSIS in SQL Server 2008 R2 November CTP

Ok, so it turns my previous post about R2 wasn’t entirely correct. SSIS does have one new feature which appears in the latest SQL Server 2008 R2 CTP . If you open up the ADO.NET Destination UI, you’ll notice a new “Use Bulk Insert when Possible” check
Posted by mmasson | 0 Comments
Filed under: , , ,
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