Handling Slowly Changing Dimensions in SSIS

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 Dimension Transform in SSIS, and also…


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 did all of its…