I had a great time at PASS last week, and had a chance to talk to a lot of different SSIS users. One of the big topics seemed to be Slowly Changing Dimensions – I had a number of people ask for various improvements to the current Slowly Changing...

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