July 27th, 2012, 09:34 AM
Import Complex XML files into SQL Server
I am SQL Developer and new to C# programming. Got a chance to learn C# to accomplish a task. Here it is-
I have about 5000 complex XML files needo extract the fileds and load into SQL Server 2008R2. I tried it to do it in my area(SQL & SSIS) but not achieved because of complex in structure. XML sourece in SSIS can't handle the files. My lead suggested me to do using VB or C# coding. Fileds i need are not under same node and Path in all files.
Can anyone please tell me how to extract data from XML and store into SQL. Any material/links to get overview about classes and methods related to XML and SQl are appreciated.
Thanks in Advance!
Tags for this Thread
Click Here to Expand Forum to Full Width