BI Thoughts and Theories

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...

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...

There's been a few questions on the forums recently about taking column values and pivoting them to rows. For example, I might have an input file with 5 columns: a key column and 4 category columns. Key; C1; C2; C3; C4 1;1;2;3;4 2;1;2;3;4 3;1;2;3;4 4;1;2;3;4 Read More...