| Author |
Topic |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2012-08-06 : 12:50:57
|
| I Have a lot of XML files (has the same structure) which I need to parse into an SQL SERVER 2008 Table.These XML files have a very complex structure.I have read on some articles that I have to normalize it.Any help will be appreciated.Thanks.--------------------------Joins are what RDBMS's do for a living |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-06 : 12:52:05
|
| hmm...cant you use a data flow task with XML source and OLEDB destination if structure is static?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-06 : 14:47:31
|
| visakh16 thanks,I have thought of doing that, but I have no XSD file, and to Edit the XML source item you need to specify the location of the XSD.I honestly dont have a strong foundation of what to start with and what I need.can you provide the requirements I need to know and have please in order to succeed this task?Thanks :)--------------------------Joins are what RDBMS's do for a living |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-06 : 15:01:28
|
| You can generate an XSD file from the data using xsd.exe. It is a command line tool that is part of the Visual Studio tools. (From Start->Visual Studio -> Visual Studio Tools -> Visual Studio Command Propmt and then you can run xsd.exe with the xml file as the first argument). |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-06 : 15:10:20
|
quote:
Originally posted by xhostx
visakh16 thanks,I have thought of doing that, but I have no XSD file, and to Edit the XML source item you need to specify the location of the XSD.I honestly dont have a strong foundation of what to start with and what I need.can you provide the requirements I need to know and have please in order to succeed this task?Thanks :)--------------------------Joins are what RDBMS's do for a living
you can generate XSD within ssis itself. It has generate schema option available from XML Source------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-06 : 15:42:27
|
| Thank you Both,Now, that I have the schema, Is there any techniques to help map my Schema file to a future SQL Table because the this SCHEMA has so many sub elements?Thanks--------------------------Joins are what RDBMS's do for a living |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-06 : 15:58:43
|
quote:
Originally posted by xhostx
Thank you Both,Now, that I have the schema, Is there any techniques to help map my Schema file to a future SQL Table because the this SCHEMA has so many sub elements?Thanks--------------------------Joins are what RDBMS's do for a living
you mean store xsd schema as a value inside table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-06 : 16:12:38
|
| Nope, Now I have both XSD and my XML file.I'm planning on creating an SQL Table that stores the original values of my XML file.Im looking to find a way to normalize (logically) that schema to be easy to understood and I can base on that schema to design my SQL Table!Does it make sense--------------------------Joins are what RDBMS's do for a living |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-06 : 16:19:47
|
quote:
Originally posted by xhostx
Nope, Now I have both XSD and my XML file.I'm planning on creating an SQL Table that stores the original values of my XML file.Im looking to find a way to normalize (logically) that schema to be easy to understood and I can base on that schema to design my SQL Table!Does it make sense--------------------------Joins are what RDBMS's do for a living
By original values due you mean data inside XML document? if yes, data flow task with xml source should be able to extract it out for you------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
XML with SSIS