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
This is a CodeGuru survey question.