Lets assume I have the following XML:
If I use the following schema document:
<?xml version="1.0" encoding="utf-8"?>
<xs:element name="DateCreate" type="xs:dateTime" />
I'm getting an error when trying to load this in SSIS saying the following...
[XML Source ] Error: The component "XML Source" (1) was unable to process the XML data. The Xml source document contains multiple "DateCreate" elements and maxOccurs=1 was specified in the Xml schema.
I only want to pull in the DateCreate field in the People Node Level, Not in the Attribute Node level but it's trying to pull both in and says it can't do that.
Any Ideas on a fix?