The last video nugget that I produced seemed to be fairly well received so I thought I would attempt a few more; and indeed, here is the next one. In this video I demonstrate a simple technique for outputting data to an XML file using SSIS’s Script Task.
The video is 8m22s long and is embedded below however I’m aware of some problems that we are having, at the time of writing, with embedding of videos here on SQLBlog so for the time being head over to http://vimeo.com/9781950 where it can be viewed.
If you are so inclined I have made the package that I built whilst recording this demonstration available on my SkyDrive for your reference.
I look forward to your comments.