I am trying to use SQLXMLBulkLoad to load some xml formatted data into SQL Server.
The XML is formatted as follows...
Code:
<Financials>
<FinancialRecord Num="00001">
<OIDNr>000000013715</OIDNr>
<FinancialAttrDt>6/12/2007 11:31:59 AM</FinancialAttrDt>
<RowCreatedBy>024405</RowCreatedBy>
<RowCreatedTs>6/12/2007 11:31:59 AM</RowCreatedTs>
<RowUpdatedBy>024405</RowUpdatedBy>
<RowUpdatedTs>6/12/2007 11:31:59 AM</RowUpdatedTs>
<SourceSystem>InitialDataLoad</SourceSystem>
</FinancialRecord>
<FinancialRecord Num="00005">
<OIDNr>000000005797</OIDNr>
<FinancialAttrDt>6/12/2007 11:31:59 AM</FinancialAttrDt>
<RowCreatedBy>024405</RowCreatedBy>
<RowCreatedTs>6/12/2007 11:31:59 AM</RowCreatedTs>
<RowUpdatedBy>024405</RowUpdatedBy>
<RowUpdatedTs>6/12/2007 11:31:59 AM</RowUpdatedTs>
<SourceSystem>InitialDataLoad</SourceSystem>
</FinancialRecord>
</Financials>
I am having troubles creating the schema file correctly. I get errors with everything I try. Mostly "No data was provided for column 'OIDNr' on table 'FIN.FinancialAttributeAll', and this column cannot contain NULL values"
My schema files currently looks as follows...
Code:
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:element name="Financials" sql:relation="FIN.FinancialAttributeAll">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="OIDNr" type="xsd:string" sql:field="OIDNr"/>
<xsd:element name="FinancialAttrDt" type="xsd:dateTime" sql:field="FinancialAttrDt" sql:datatype="dateTime"/>
<xsd:element name="RowCreatedBy" type="xsd:string" sql:field="RowCreatedBy"/>
<xsd:element name="RowCreatedTs" type="xsd:string" sql:field="RowCreatedTs" sql:datatype="dateTime"/>
<xsd:element name="RowUpdatedBy" type="xsd:string" sql:field="RowUpdatedBy"/>
<xsd:element name="RowUpdatedTs" type="xsd:string" sql:field="RowUpdatedTs" sql:datatype="dateTime"/>
<xsd:element name="SourceSystem" type="xsd:string" sql:field="SourceSystem"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
Any ideas how to format this correctly?
SQLXMLBulkLoad Help
