Agile BI Community

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, the XML Task allows you to do this by running an XPath query. To configure the task, ...

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 XML string containing his row values to save into a column of a database table. So instead of ...

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, it doesn't take much work at all. This was also a good opportunity for me to use a ...

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; C41;1;2;3;42;1;2;3;43;1;2;3;44;1;2;3;4 and I'd like an output that has 2 columns (the key and the category ...