select xml data column into flat reporting table
Posted
by Bernard
on Stack Overflow
See other posts from Stack Overflow
or by Bernard
Published on 2010-06-17T09:50:34Z
Indexed on
2010/06/17
9:53 UTC
Read the original article
Hit count: 142
Filed under:
sql-server
|ssis
We have a xml column in SQL Server 2008. We need to do reporting off the data in the xml so we're going to select the xml into a flat table. The flat table has columns that correspond to various nodes in the xml.
What is the best way to do this using SSIS?
Is this a good approach? Or should we just try and write the reports directly off the xml column?
© Stack Overflow or respective owner
