April 2007 Entries

BizTalk and SSIS

I’ve been interesting in using SSIS ever since I first heard about it. Since I specialize in doing integration work, primarily with BizTalk, I was curious about this new “Integration Services” component of SQL Server. I was a little bit worried that it would supplant BizTalk for a lot of integration scenarios (worried since I’ve invested so much time understanding BizTalk). Since SQL2005 was released I have had a chance to read a lot more about SSIS and also to use it in a couple of projects. I am ......