Import XML file to SQL DB Task - xml with multiple namespaces

Completato Pubblicato 5 anni fa Pagato alla consegna
Completato Pagato alla consegna

HI

I need a simple solution to load xml file with multiple namespaces to sql table , Ideally via SSIS but stored procedure will also be ok .

As file contains multiple namespaces with various depth standard SSIS XML data flow task is failing to import all the data.

XML file is the response from ebay api LMS saved on local PC.

eBay Server Microsoft SQL Architettura Software SQL XML

Rif. progetto: #18102632

Info sul progetto

4 proposte Progetto a distanza Attivo 5 anni fa

Assegnato a:

iaroslavk

Hello, My name is Iaroslav Kasianenko and I work as Senior BI Developer. I'm a database professional with 7+ years of experience. Thus, in my humble opinion I'm a right person to take over this task. Please provide Altro

£23 GBP in 1 giorno
(1 Recensione)
2.1

4 freelance hanno fatto un'offerta media di £20 per questo lavoro

sumon355

Hello, As an expert in ms sql server, i am very much interested to do this task. I can provide you a vb.net solution for this if you like. May i see an xml file? Thanks

£24 GBP in 1 giorno
(268 valutazioni)
7.5
vw7590795vw

Please message me. 1. Kindly send me your sample XML file and expected output from it in excel file. 2. Send me table design and mapping between table column and XML node or attribute. Please review my profile. http Altro

£20 GBP in 1 giorno
(22 valutazioni)
4.1
nguyenvanlong

have good XML parse, Spring batch, Jdbc batch. i can help you to completed this task/ As file contains multiple namespaces with various depth standard SSIS XML data flow task is failing to import all the data. S Altro

£13 GBP in 1 giorno
(0 valutazioni)
0.0