alter PROCEDURE [dbo].[spXMLBulkLoad] (
	 @@File		SysName
	,@@Schema	SysName
	,@@DataBase	SysName	= '<DefaultDataBase>'
) AS BEGIN -- EXEC dbo.spXMLBulkLoad 'Z:\Path\Data.xml','Z:\Path\Schema.xsd'
	 --EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE WITH OVERRIDE;
	DECLARE	 @ErrCode	Int
		,@OLEXMLBulk	Int
		,@ErrMethod	SysName
		,@ErrSource	SysName
		,@ErrDescript	NVarChar(4000)
	SET @ErrSource = 'E:\SQLXML\error.log'	--  файл ошибки (OPENROWSET требует константу)
	EXEC @ErrCode = sys.sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload' ,@OLEXMLBulk OUT
	IF (@ErrCode = 0) BEGIN
		SET	@@DataBase	= 'Provider=SQLOLEDB;Data Source=.;DataBase=' + @@DataBase + ';Integrated Security=SSPI;CODEPAGE=1251;'
		EXEC @ErrCode = sys.sp_OASetProperty	@OLEXMLBulk ,'ConnectionString'	,@@DataBase		IF (@ErrCode != 0) BEGIN SET @ErrMethod = 'ConnectionString'	GOTO Error END
		EXEC @ErrCode = sys.sp_OASetProperty	@OLEXMLBulk ,'ErrorLogFile'	,@ErrSource		IF (@ErrCode != 0) BEGIN SET @ErrMethod = 'ErrorLogFile'	GOTO Error END
		EXEC @ErrCode = sys.sp_OASetProperty	@OLEXMLBulk ,'CheckConstraints'	,0			IF (@ErrCode != 0) BEGIN SET @ErrMethod = 'CheckConstraints'	GOTO Error END
		EXEC @ErrCode = sys.sp_OASetProperty	@OLEXMLBulk ,'KeepIdentity'	,0			IF (@ErrCode != 0) BEGIN SET @ErrMethod = 'Transaction'	GOTO Error END
		EXEC @ErrCode = sys.sp_OASetProperty	@OLEXMLBulk ,'Transaction'	,1			IF (@ErrCode != 0) BEGIN SET @ErrMethod = 'Transaction'	GOTO Error END
		EXEC @ErrCode = sys.sp_OASetProperty	@OLEXMLBulk ,'SchemaGen'	,0			IF (@ErrCode != 0) BEGIN SET @ErrMethod = 'SchemaGen'	GOTO Error END



		EXEC @ErrCode = sys.sp_OAMethod		@OLEXMLBulk ,'Execute', NULL	,@@Schema, @@File
		IF (@ErrCode != 0) BEGIN
			SET @ErrMethod = 'Execute'
			DECLARE	 @Exist	Int
				,@Error	XML
			EXEC	master.dbo.xp_FileExist	@ErrSource, @Exist OUT
			IF (@Exist = 1) BEGIN
				SELECT	 @Error		= E.Error
							-- Обход глюка
							+ CASE	WHEN Right(E.Error,1) != '>'	THEN 'lt>'
								ELSE ''				END
				FROM	OPENROWSET(BULK 'E:\SQLXML\error.log',SINGLE_NCLOB)E(Error) -- Из @ErrSource файла
				SELECT	@ErrDescript	= IsNull(@ErrDescript	,'') + E.Error.value('Description[1]','SysName') + ' '
				FROM	@Error.nodes('/Result/Error')E(Error)
				SELECT	@ErrDescript	= IsNull(@ErrDescript	,'') + E.Error.value('Description[1]','SysName') + ' '
				FROM	@Error.nodes('/Error/Record')E(Error)
			END ELSE
				GOTO Error
		END
		GOTO Destroy
	Error:	EXEC @ErrCode = sys.sp_OAGetErrorInfo	@OLEXMLBulk ,@ErrSource OUT ,@ErrDescript OUT
	Destroy:EXEC @ErrCode = sys.sp_OADestroy	@OLEXMLBulk
	END ELSE
		SELECT	 @ErrMethod	= 'SQLXMLBulkLoad.SQLXMLBulkload'
			,@ErrSource	= 'sp_OACreate'
			,@ErrDescript	= 'Ошибка создания OLE объекта'
	-- Вывод ошибок
	IF (@ErrMethod IS NOT NULL) BEGIN
		RAISERROR('Ошибка при выполнении метода "%s" в "%s": %s',18,1,@ErrMethod,@ErrSource,@ErrDescript)
		RETURN	@@Error
	END
END

<?xml version="1.0"?>
<xsd:schema attributeFormDefault="unqualified" elementFormDefault="qualified" version="1.0" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema" >
 <xsd:annotation>
  <xsd:appinfo>
   <sql:relationship name="itmp_EXP_itmp_ZL_LIST" parent="itmp_ZL_LIST" parent-key="ID" child="itmp_EXP" child-key="PID" />
  </xsd:appinfo>
 </xsd:annotation>
    <xsd:element name="ZL_LIST" sql:relation="itmp_ZL_LIST" sql:key-fields="ID">
     <xsd:complexType>
      <xsd:sequence>
       <xsd:element name="ZGLV" sql:is-constant="1">
        <xsd:complexType>
         <xsd:sequence>
             <xsd:element name="VERSION" sql:is-constant="1" />
             <xsd:element name="DATA" sql:is-constant="1" />
             <xsd:element name="FILENAME" sql:is-constant="1" />
         </xsd:sequence>
        </xsd:complexType>
       </xsd:element>
       <xsd:element maxOccurs="unbounded" name="EXP" sql:relation="itmp_EXP" sql:relationship="itmp_EXP_itmp_ZL_LIST" sql:key-fields="ID" >
        <xsd:complexType>
         <xsd:all minOccurs="1">
	  <xsd:element minOccurs="0" name="YEAR" type="xsd:unsignedShort" sql:datatype="varchar(1000)" />
	  <xsd:element minOccurs="0" name="MONTH" type="xsd:unsignedByte" sql:datatype="varchar(1000)" />
         </xsd:all>
        </xsd:complexType>
       </xsd:element>
      </xsd:sequence>
     </xsd:complexType>
    </xsd:element>
</xsd:schema>

<?xml version="1.0" encoding="windows-1251"?>
<ROOT>
  <T1>
    <P1>3</P1>
	<T2>
		<P21>12</P21>
	</T2>
	<T2>
		<P21>122</P21>
	</T2>
  </T1>
  <T1>
    <P1>31</P1>
  </T1>
</ROOT>

<?xml version="1.0" encoding="windows-1251"?>
<xsd:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
 <xsd:annotation>
  <xsd:appinfo>
   <sql:relationship name="FK_R_T1" parent="t_ROOT" parent-key="id" child="t_T1" child-key="pid" />
   <sql:relationship name="FK_T1_T2" parent="t_T1" parent-key="id" child="t_T2" child-key="pid" />
  </xsd:appinfo>
 </xsd:annotation>
	<xsd:element name="ROOT" sql:relation="t_ROOT" sql:key-field="id">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="T1" sql:relation="t_T1" sql:relationship="FK_R_T1" sql:key-field="id"  >
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="P1" type="xsd:decimal" sql:datatype="decimal"/>
							<xsd:element name="T2" sql:relation="t_T2" sql:relationship="FK_T1_T2" sql:key-field="id"  >
								<xsd:complexType>
									<xsd:sequence>
										<xsd:element name="P21" type="xsd:decimal" sql:datatype="decimal"/>
									</xsd:sequence>
								</xsd:complexType>
							</xsd:element>
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
</xsd:schema>

<?xml version="1.0" encoding="windows-1251"?>
<ROOT>
  <T1>
    <P1>3</P1>
	<T2>
		<P21>12</P21>
		<P21>122</P21>
	</T2>
  </T1>
  <T1>
    <P1>31</P1>
  </T1>
</ROOT>