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...

There was a very lively connect issue about SSIS’ lack of support for VS 2010. Jeff Bernhardt recently posted an official reply on the thread, and I thought it would be good to repost it here: First of all, thank you to those customers who have offered...

The Pacific Northwest SQL Server Users Group has invited me to come speak to them about SSIS next week (Wednesday, May 12th). I’ll be presenting a preview version of my Performance Design Patterns talk that I put together for the MS BI Conference in June...