question

Mrs_Fatherjack avatar image
Mrs_Fatherjack asked

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
ssisxmlxsd
10 |1200

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

Usman Butt avatar image
Usman Butt answered
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 comment
10 |1200

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

That's done it, many thanks.
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
Have you checked the exact case? XML is case sensitive.
1 comment
10 |1200

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

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 Likes 0 ·
Dave_Green avatar image
Dave_Green answered
Do you still get the issue if you get SSIS to generate the XSD?
10 |1200

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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