Browse by Tags

Tagged Content List
  • Blog Post: ADO.NET Destination package format change in SQL 2008 R2

    As I previously mentioned , SQL 2008 R2 added new Bulk Insert functionality to the ADO.NET Destination. This changed the component version, which means that if you edit/save packages that have ADO.NET Destination components in R2, the package will give you a loading error when you use it on a 2008 (R1...
  • Blog Post: 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 box. Previously, the ADO.NET Destination...
  • Blog Post: 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 row basis. Since the preferred methods of connecting...
  • Blog Post: 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. My overall findings was that while there were quirks, both the ODBC and ADO.Net drivers that I tried worked fine. Both drivers...
Page 1 of 1 (4 items)