Integrating SharePoint Data with SQL Server

LISTING 3: XML Schema

<xs:schema xmlns:ns1="#RowsetSchema" attributeFormDefault="unqualified" elementFormDefault="qualified"
   targetNamespace="#RowsetSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="data">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" maxOccurs="unbounded" name="row">
          <xs:complexType>
            <xs:attribute name="ows_Title" type="xs:string" use="optional" />
            <xs:attribute name="ows__ModerationStatus" type="xs:unsignedByte" use="optional" />
            <xs:attribute name="ows__Level" type="xs:unsignedByte" use="optional" />
            <xs:attribute name="ows_EventDate" type="xs:string" use="optional" />
            <xs:attribute name="ows_AVMStatus" type="xs:string" use="optional" />
            <xs:attribute name="ows_ID" type="xs:unsignedByte" use="optional" />
            <xs:attribute name="ows_owshiddenversion" type="xs:unsignedByte" use="optional" />
            <xs:attribute name="ows_UniqueId" type="xs:string" use="optional" />
            <xs:attribute name="ows_FSObjType" type="xs:string" use="optional" />
            <xs:attribute name="ows_Created" type="xs:string" use="optional" />
            <xs:attribute name="ows_AVMAbsenceType" type="xs:string" use="optional" />
            <xs:attribute name="ows_EndDate" type="xs:string" use="optional" />
            <xs:attribute name="ows_Employee_x0020_Name" type="xs:string" use="optional" />
            <xs:attribute name="ows_FileRef" type="xs:string" use="optional" />
            <xs:attribute name="ows_MetaInfo" type="xs:string" use="optional" />
            <xs:attribute name="ows_Description" type="xs:string" use="optional" />
            <xs:attribute name="ows_fAllDayEvent" type="xs:unsignedByte" use="optional" />
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

LISTING 4: SQL Script to Create a Destination Table

USE [AdventureWorks]
GO
CREATE TABLE [dbo].[Absences](
   [ID] [int] IDENTITY(1,1) NOT NULL,
   Integrating SharePoint Data with SQL Server  [nvarchar](255) NOT NULL,
   [EmployeeName] [nvarchar](255) NULL,
   [AbsenceType] [nvarchar](255) NULL,
   [StartDate] [datetime] NULL,
   [EndDate] [datetime] NULL,
   [Description] [nvarchar](255) NULL
) ON [PRIMARY]
GO