Using XML Source File with SSIS

Question

question

Mrs_Fatherjack asked Apr 12, '12

Using XML Source File with SSIS

I wonder if anyone can advise, I have an xml file as below: 11 2011-01-02 00:00:01 Using this XSD file But in the SSIS package it doesn't recognise the field names. I'm new to using XML and any help would be very greatfully received. Many thanks

ssis xml xsd

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-04-12T13:08:19Z

Usman Butt answered Apr 12, '12

Try after adding `` in your xml. I guess your xml would be something like 11 2011-01-02 00:00:01 and your xsd could be Basically, the root tag is missing in the xml file. You can name it anything. Hope it helps.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mrs_Fatherjack commented · Apr 12, 2012 at 03:38 PM

That's done it, many thanks.

0 ·

Answer 2 · 2012-04-12T11:24:31Z

Kev Riley answered Apr 12, '12

Have you checked the exact case? XML is case sensitive.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mrs_Fatherjack commented · Apr 12, 2012 at 12:31 PM

As far as I can tell it's all the same, our database uses case sensitive collation so I'm used to checking it.

0 ·

Answer 3 · 2012-04-12T12:43:09Z

Dave_Green answered Apr 12, '12

Do you still get the issue if you get SSIS to generate the XSD?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question