Richard and I talk to Matthew Roche about SQL Server Integration Services (SSIS). SSIS comes with SQL Server 2005 and 2008, replacing Data Transformation Services (DTS) from SQL Server 2000. Matthew digs into the dramatic improvements SSIS has over DTS and some of the best practices for using SSIS. Check out Matthew’s blog here.

Microsoft SQL Server MVP Matthew Roche is a Data Architect with systems management innovator Configuresoft, Inc., and is also Chief Software Architect of Integral Thought & Memory, a BI-focused consultancy. Matthew has worked with Microsoft SQL Server since the mid 90s, starting with SQL Server 6.0 and 6.5, and has been falling deeper and deeper in love with SQL Server with each passing year. As a Microsoft Certified Trainer, Matthew has taught hundreds of database administrators and database developers how to better utilize SQL Server’s capabilities. As a software developer and architect, Matthew has built dozens of applications that use the SQL Server platform. Matthew has been using SQL Server 2005 since its early beta days and has been working with SQL Server 2008 since early 2007. Matthew’s current focus is on the SQL Server Business Intelligence stack, specifically SQL Server Integration Services. Today, when not delivering training, presenting on BI topics at conferences, or listening to the world’s loudest heavy metal, Matthew is hard at work helping design and build Configuresoft’s Configuration Intelligence Analytics (CIA) platform for bringing the power of BI to enterprise IT.