Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to import the following XML using Integration Services?

April 26, 2017import Integration Services XML

0

10 Posted

How to import the following XML using Integration Services?

1 Answer

0

10 Posted

Hi, I use the SQL Server 2005 June CTP and I need to import the following XML into a database table. I tried to generate a XSD out of it, but SQL Server got confused about the repeating tags I’m afraid. The resulting XSD could not be used in integration services. I’m a newbie to the XML stuff, so any help is really very welcome! Thank you very much. Sascha Here is the (simplified) XML. Unfortunately, the format is given and I cannot change it. We can ignore the part and the structure of the elements is always the same.

-->