Learn SQL Server 2008 R2 Integration Services Now

The Data Platform Evangelism team has published the third unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a SQLInsights) on MSDN. The SQL Server 2008 R2 Business Intelligence Training Course (SQLInsights) will help you learn how to build your first Microsoft Business Intelligence solution. SQLInsights is a great resource for developers, consultants…


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…


Tutorial: SSIS Performance Videos

This post is coming a little late (these have already been announced here and here), but incase you haven’t seen these before, I wanted to bring attention to four new performance related created by the SQLCAT and SSIS teams. They mostly focus on larger scale/Enterprise level package deployments, but there are good tips for all…