December 22, 2018 at 7:04 am
Hi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in Advance
December 22, 2018 at 8:05 am
RamSteve - Saturday, December 22, 2018 7:04 AMHi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in Advance
Somehow the attachment isn't there, would help if it was 😉
😎
The problem with XML imports in SSIS is that the Integration services will "reverse engineer " the XSD, which produces nothing but some very funny results. My advice is to get the appropriate XSD to import into the SSIS XML task, "normalize" the structure using XQuery and T-SQL or, as a last resort, fully model the XML schema and create the matching DDL.
December 23, 2018 at 2:07 am
Eirikur Eiriksson - Saturday, December 22, 2018 8:05 AMRamSteve - Saturday, December 22, 2018 7:04 AMHi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in AdvanceSomehow the attachment isn't there, would help if it was 😉
😎The problem with XML imports in SSIS is that the Integration services will "reverse engineer " the XSD, which produces nothing but some very funny results. My advice is to get the appropriate XSD to import into the SSIS XML task, "normalize" the structure using XQuery and T-SQL or, as a last resort, fully model the XML schema and create the matching DDL.
Attached the sample XML file
December 23, 2018 at 5:21 am
Steve Dell - Sunday, December 23, 2018 2:07 AMEirikur Eiriksson - Saturday, December 22, 2018 8:05 AMRamSteve - Saturday, December 22, 2018 7:04 AMHi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in AdvanceSomehow the attachment isn't there, would help if it was 😉
😎The problem with XML imports in SSIS is that the Integration services will "reverse engineer " the XSD, which produces nothing but some very funny results. My advice is to get the appropriate XSD to import into the SSIS XML task, "normalize" the structure using XQuery and T-SQL or, as a last resort, fully model the XML schema and create the matching DDL.
Attached the sample XML file
This XML is rather complex and parsing it will take a considerable effort. My preference would be to use XQuery and the nodes() method for the work rather than SSIS as the it is similar effort but the results from the XQuery method is more manageable and accurate.
😎
Two suggestions, use a diagram editor to model the XML and keep a "Master Data Management" in a spreadsheet, can save a lot of effort going forward.
December 23, 2018 at 11:01 pm
Steve Dell - Saturday, December 22, 2018 7:04 AMHi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in Advance
I Guess this can be achieved by doing the XSL Transformation like DeNormalizing the XML file .Can some one help in creating the .XSL transformation for the attached XML file . Thanks in Advance 🙂
January 7, 2019 at 12:01 am
Steve Dell - Saturday, December 22, 2018 7:04 AMHi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in Advance
I have achieved this by parsing the XML file by using script task .In C# this can be done by using the XDocument and Linq which could be much easier
January 7, 2019 at 4:42 am
Steve Dell - Sunday, December 23, 2018 2:07 AMEirikur Eiriksson - Saturday, December 22, 2018 8:05 AMRamSteve - Saturday, December 22, 2018 7:04 AMHi ,
can someone please help me in getting the simple method of parsing the XML file in SSIS. I was using the XML source but it gives me bunch of 50-100 tables. is there a way of getting some examples of Script task paring XML file to Dataset or so .. Please find my attached XML file for your reference
Thanks in AdvanceSomehow the attachment isn't there, would help if it was 😉
😎The problem with XML imports in SSIS is that the Integration services will "reverse engineer " the XSD, which produces nothing but some very funny results. My advice is to get the appropriate XSD to import into the SSIS XML task, "normalize" the structure using XQuery and T-SQL or, as a last resort, fully model the XML schema and create the matching DDL.
Attached the sample XML file
So did you later detach the file? I'm asking because I've checked your posts on this thread and none of them have an attachment.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply