Post reply

xml data type field in sql table

  • January 15, 2008 at 5:43 am

    #119936

    Hi,

    I am extremely new to SSIS & SSAS. I have a table with a field of data type xml. I need to cube this data and then use it for reporting.

    I'm assuming I can create a SSIS package to translate the data from xml data type to dimensions.

    Most examples on the net shows u how to load xml to sql, this is not what i want, i want to read from an xml data type.

    How do u suggest I go about doing this?

  • January 15, 2008 at 9:26 am

    #768216

    Last year there was a series of articles titled "XML Workshop" published at SSC by Jacob Sebastian. Lots of interesting examples of how to read data from the XML datatype. One of the links: http://www.sqlservercentral.com/articles/Basics/3117/

    Peter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply