BI Thoughts and Theories

I came across a question about this the other day, and thought I'd share the answer here, as there doesn't seem to be much information out there about it.  The questioner wanted to know how to read a portion of an XML document into a variable. Fortunately, 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...

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