SQLXMLBulkLoad for Repeated Child Elements

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SQLXMLBulkLoad for Repeated Child Elements

Author

Topic

UpsideDownTire
Starting Member

6 Posts

Posted - 2009-06-22 : 11:45:03

Hi everyone,

I am in need of some assistance with the handling a child element that is mostly not repeated but when it is, BulkLoad rejects the entire XML file.

I have tried using the sql:overflow-field="OverflowColumn" in my xsd, but I still get the error "In the same scope elements with the same mame, 'BusinessName', have to be the same type."

My understanding of the sql:overflow-field is that it collects data not defined in the xsd. Is that correct?

The sql:overflow-field is not use to collect data that has caused an error, correct?

The data here has been fabricated for demostrate of the error.


<Parent>
...
<Conference>
        <ConferenceName>Soap Conference</ConferenceName>
        <ScheduledDate>2001-01-01</ScheduledDate>
        <City>San Jose, CA</City>
        <ParticipantList>
                <Participant>
                        <BusinessName>XYZ Soaps</BusinessName>
                        <Name>George Smith</Name>
                        <DisplayTableLocation>C-1</DisplayTableLocation>
                        <DoorPrize>Soap Dispenser</DoorPrize>
                        <RegistrationFeePaid>Yes</RegistrationFeePaid>
                        <SocietyMember>Yes</SocietyMember>
                </Participant>
                <Participant>
                        <BusinessName>Rubber Duck, Inc.</BusinessName>
                        <Name>Sam Edwards</Name>
                        <RegistrationFeePaid>Yes</RegistrationFeePaid>
                        <SocietyMember>No</SocietyMember>
                </Participant>
        </ParticipantList>
</Conference>
...
</Parent>

Thank you for your time and help.

UDT

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources