So now I’m all excited this week, because in this 11 part webcast series I finally get to write some code. Today’s webcast Advanced SQL Server 2005 DTS will give us the chance to see how an Integration Services package can be constructed dynamically at runtime from code that we will develop. I’ll be writing the code in C#, but if you’re familiar with VB.Net you should be able to follow along (just remove the semi-colons and change the variable declarations a little)…The idea is that although the designers work well for most things, sometimes you need to customize advanced features or dynamically create things at runtime. I’ve posted the code on http://www.BenkoTIPS.com so you can explore or follow along with it.
Next week I’ll be in Boston for TechED and we’ll run our webcast on Data Mining, the last of this series on how to use the new features of Business Intelligence in SQL Analysis Services. If I hear of anything cool that will be coming I’ll be sure to report back to you on what’s possible.
– Mike