|
|
Browse by Tags
All Tags » Examples » XML
-
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 ...
|
|
|