BI Thoughts and Theories

It's been a busy couple of weeks, but I've finally found some time to play around with the June CTP of SQL Server 2008. One of the items that caught my interest was the MERGE statement. This is a new addition to the T-SQL language that lets you perform Read More...

Previously, I posted about using a script destination component to output an XML file . A post on the MSDN forums got me thinking about a slight tweak to the previous post that would result in a little more flexibility. The poster wanted to create an Read More...

In my previous post, I discussed how to use a script destination to output multiple flat files from a single source. In it, I mentioned that I would post an alternate approach, that didn't require any scripting. So, here it is. This is using the same Read More...

Yesterday I posted about using a destination script component to write XML files from a data flow. Today, I'm continuing in the same vein with a post about writing multiple destination files from a destination script component. The inspiration for this Read More...

I often hear comments along the lines of "Why doesn't SSIS have an XML destination?". Unfortunately, I don't know the answer to that, but I can show you how to implement your own XML destination fairly easily. Thanks to the magic of the script component, Read More...