нужно сделать массовую вставку из XML в таблицу на MS SQL 2005..
при этом возникла проблема.. всавка происходит но не всех данных из xml-файла..

вот сам xml:

<?xml version="1.0" encoding="windows-1251"?>
<user_info>
<format_version>2</format_version>
<ric>445</ric>
<res_version>3000.03.45.10055</res_version>
<tech_info>
<OS>
<Name>Windows Server 2003 Service Pack 2</Name>
<Version
Major="5"
Minor="2"
/>
<Build>3790</Build>
<PlatformID>2</PlatformID>
</OS>
<DiskFreeSpace>17540</DiskFreeSpace>
<Users
OD="0"
UD="0"
TS="0"
/>
</tech_info>
<files>
<USR_FILE date="29.12.2008" time="17.34" kind="P" />
<info.cod date="19.10.2005" time="13.33" />
<consult.tor date="08.10.2008" time="13.14" />
</files>
<package>
<LAW_1
distr="236170"
comp="2"
ric="445"
netCount="1"
userType="VIP"
technolType=""
/>
<FIN_17
distr="83199"
comp="2"
ric="445"
netCount="1"
userType="VIP"
technolType=""
/>
<PAP_6
distr="82382"
comp="2"
ric="445"
netCount="0"
userType="VIP"
technolType=""
/>
<APV_33
distr="80100"
comp="2"
ric="445"
netCount="0"
userType="VIP"
technolType=""
/>
<RLAW328_7
distr="3297"
comp="1"
ric="328"
netCount="0"
userType="USR"
technolType=""
/>
</package>
<ib>
<PBI nDistr="83199" nComp="2" directory="PBI" name="Бухгалтерская пресса и книги" nCat="119043" nTexts="119043" n3="119043" n4="119043" n5="119043" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.30" sysdate="29.12.2008" docs="119043" kind="P" />
<u2 date="23.12.2008" time="15.11" sysdate="23.12.2008" docs="118532" kind="P" />
<u3 date="16.12.2008" time="15.04" sysdate="16.12.2008" docs="118108" kind="P" />
<u4 date="09.12.2008" time="15.46" sysdate="09.12.2008" docs="117727" kind="P" />
<u5 date="02.12.2008" time="15.18" sysdate="02.12.2008" docs="117230" kind="P" />
<u6 date="25.11.2008" time="15.21" sysdate="25.11.2008" docs="116726" kind="P" />
<u7 date="18.11.2008" time="15.12" sysdate="18.11.2008" docs="116233" kind="P" />
<u8 date="11.11.2008" time="15.05" sysdate="11.11.2008" docs="115731" kind="P" />
<u9 date="05.11.2008" time="18.02" sysdate="05.11.2008" docs="115311" kind="P" />
<u10 date="28.10.2008" time="15.00" sysdate="28.10.2008" docs="114835" kind="P" />
</updates>
</PBI>
<LAW nDistr="236170" nComp="2" directory="LAW" name="Версия Проф" nCat="82959" nTexts="82959" n3="82959" n4="82959" n5="82959" n6="0" compliance="#HOST">
<updates>
<u1 date="29.12.2008" time="17.31" sysdate="29.12.2008" docs="82959" kind="P" /><u2 date="23.12.2008" time="15.12" sysdate="23.12.2008" docs="82701" kind="P" /><u3 date="16.12.2008" time="15.04" sysdate="16.12.2008" docs="82463" kind="P" /><u4 date="09.12.2008" time="15.46" sysdate="09.12.2008" docs="82199" kind="P" /><u5 date="02.12.2008" time="15.16" sysdate="02.12.2008" docs="81981" kind="P" /><u6 date="25.11.2008" time="15.19" sysdate="25.11.2008" docs="81738" kind="P" /><u7 date="18.11.2008" time="15.10" sysdate="18.11.2008" docs="81491" kind="P" /><u8 date="11.11.2008" time="15.03" sysdate="11.11.2008" docs="81313" kind="P" /><u9 date="05.11.2008" time="16.59" sysdate="05.11.2008" docs="81219" kind="P" /><u10 date="28.10.2008" time="14.58" sysdate="28.10.2008" docs="80941" kind="P" />
</updates>
</LAW>
<PAP nDistr="82382" nComp="2" directory="PAP" name="Деловые бумаги" nCat="41095" nTexts="41095" n3="41095" n4="41095" n5="41095" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.33" sysdate="29.12.2008" docs="41095" kind="P" /><u2 date="23.12.2008" time="15.14" sysdate="23.12.2008" docs="40965" kind="P" /><u3 date="16.12.2008" time="15.07" sysdate="16.12.2008" docs="40850" kind="P" /><u4 date="09.12.2008" time="15.49" sysdate="09.12.2008" docs="40775" kind="P" /><u5 date="02.12.2008" time="15.19" sysdate="02.12.2008" docs="40675" kind="P" /><u6 date="25.11.2008" time="15.22" sysdate="25.11.2008" docs="40475" kind="P" /><u7 date="18.11.2008" time="15.13" sysdate="18.11.2008" docs="40385" kind="P" /><u8 date="11.11.2008" time="15.06" sysdate="11.11.2008" docs="40270" kind="P" /><u9 date="05.11.2008" time="18.36" sysdate="05.11.2008" docs="40115" kind="P" /><u10 date="28.10.2008" time="15.01" sysdate="28.10.2008" docs="39915" kind="P" />
</updates>
</PAP>
<LAW nDistr="236170" nComp="2" directory="LAW" name="Версия Проф" nCat="82959" nTexts="82959" n3="82959" n4="82959" n5="82959" n6="0" compliance="#HOST">
<updates>
<u1 date="29.12.2008" time="17.31" sysdate="29.12.2008" docs="82959" kind="P" /><u2 date="23.12.2008" time="15.12" sysdate="23.12.2008" docs="82701" kind="P" /><u3 date="16.12.2008" time="15.04" sysdate="16.12.2008" docs="82463" kind="P" /><u4 date="09.12.2008" time="15.46" sysdate="09.12.2008" docs="82199" kind="P" /><u5 date="02.12.2008" time="15.16" sysdate="02.12.2008" docs="81981" kind="P" /><u6 date="25.11.2008" time="15.19" sysdate="25.11.2008" docs="81738" kind="P" /><u7 date="18.11.2008" time="15.10" sysdate="18.11.2008" docs="81491" kind="P" /><u8 date="11.11.2008" time="15.03" sysdate="11.11.2008" docs="81313" kind="P" /><u9 date="05.11.2008" time="16.59" sysdate="05.11.2008" docs="81219" kind="P" /><u10 date="28.10.2008" time="14.58" sysdate="28.10.2008" docs="80941" kind="P" />
</updates>
</LAW>
<RLAW328 nDistr="3297" nComp="1" directory="RLAW328" name="Республика Татарстан" nCat="38361" nTexts="38361" n3="38361" n4="38361" n5="38361" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.32" sysdate="29.12.2008" docs="38361" kind="P" /><u2 date="23.12.2008" time="15.13" sysdate="23.12.2008" docs="38257" kind="P" /><u3 date="16.12.2008" time="15.06" sysdate="16.12.2008" docs="38175" kind="P" /><u4 date="09.12.2008" time="15.47" sysdate="09.12.2008" docs="38125" kind="P" /><u5 date="02.12.2008" time="15.17" sysdate="02.12.2008" docs="38067" kind="P" /><u6 date="25.11.2008" time="15.20" sysdate="25.11.2008" docs="38012" kind="P" /><u7 date="18.11.2008" time="15.12" sysdate="18.11.2008" docs="37947" kind="P" /><u8 date="11.11.2008" time="15.04" sysdate="11.11.2008" docs="37834" kind="P" /><u9 date="05.11.2008" time="17.26" sysdate="05.11.2008" docs="37797" kind="P" /><u10 date="28.10.2008" time="14.59" sysdate="28.10.2008" docs="37714" kind="P" />
</updates>
</RLAW328>
<APV nDistr="80100" nComp="2" directory="APV" name="ФАС Поволжского округа" nCat="61229" nTexts="61229" n3="61229" n4="61229" n5="61229" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.31" sysdate="29.12.2008" docs="61229" kind="P" /><u2 date="23.12.2008" time="15.13" sysdate="23.12.2008" docs="60976" kind="P" /><u3 date="16.12.2008" time="15.05" sysdate="16.12.2008" docs="60743" kind="P" /><u4 date="09.12.2008" time="15.47" sysdate="09.12.2008" docs="60529" kind="P" /><u5 date="02.12.2008" time="15.18" sysdate="02.12.2008" docs="60318" kind="P" /><u6 date="25.11.2008" time="15.20" sysdate="25.11.2008" docs="60100" kind="P" /><u7 date="18.11.2008" time="15.12" sysdate="18.11.2008" docs="59877" kind="P" /><u8 date="05.11.2008" time="17.31" sysdate="05.11.2008" docs="59719" kind="P" /><u9 date="28.10.2008" time="14.59" sysdate="28.10.2008" docs="59054" kind="P" /><u10 date="21.10.2008" time="15.07" sysdate="21.10.2008" docs="58845" kind="P" />
</updates>
</APV>
<QUEST nDistr="83199" nComp="2" directory="QUEST" name="Финансист" nCat="64223" nTexts="64223" n3="64223" n4="64223" n5="64223" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.33" sysdate="29.12.2008" docs="64223" kind="P" /><u2 date="23.12.2008" time="15.13" sysdate="23.12.2008" docs="64016" kind="P" /><u3 date="16.12.2008" time="15.06" sysdate="16.12.2008" docs="63815" kind="P" /><u4 date="09.12.2008" time="15.48" sysdate="09.12.2008" docs="63595" kind="P" /><u5 date="02.12.2008" time="15.18" sysdate="02.12.2008" docs="63471" kind="P" /><u6 date="25.11.2008" time="15.21" sysdate="25.11.2008" docs="63270" kind="P" /><u7 date="18.11.2008" time="15.12" sysdate="18.11.2008" docs="63025" kind="P" /><u8 date="11.11.2008" time="15.04" sysdate="11.11.2008" docs="62864" kind="P" /><u9 date="05.11.2008" time="17.44" sysdate="05.11.2008" docs="62769" kind="P" /><u10 date="28.10.2008" time="15.00" sysdate="28.10.2008" docs="62522" kind="P" />
</updates>
</QUEST>
<PPN nDistr="83199" nComp="2" directory="PPN" name="Путеводитель по налогам" nCat="24" nTexts="24" n3="24" n4="24" n5="24" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.33" sysdate="29.12.2008" docs="24" kind="P" /><u2 date="23.12.2008" time="15.14" sysdate="23.12.2008" docs="23" kind="P" /><u3 date="16.12.2008" time="15.07" sysdate="16.12.2008" docs="23" kind="P" /><u4 date="09.12.2008" time="15.48" sysdate="09.12.2008" docs="23" kind="P" /><u5 date="02.12.2008" time="15.18" sysdate="02.12.2008" docs="22" kind="P" /><u6 date="25.11.2008" time="15.21" sysdate="25.11.2008" docs="22" kind="P" /><u7 date="18.11.2008" time="15.12" sysdate="18.11.2008" docs="22" kind="P" /><u8 date="11.11.2008" time="15.04" sysdate="11.11.2008" docs="22" kind="P" /><u9 date="05.11.2008" time="17.33" sysdate="05.11.2008" docs="22" kind="P" /><u10 date="28.10.2008" time="15.00" sysdate="28.10.2008" docs="22" kind="P" />
</updates>
</PPN>
<QUEST nDistr="83199" nComp="2" directory="QUEST" name="Финансист" nCat="64223" nTexts="64223" n3="64223" n4="64223" n5="64223" n6="0" compliance="=HOST">
<updates>
<u1 date="29.12.2008" time="17.33" sysdate="29.12.2008" docs="64223" kind="P" /><u2 date="23.12.2008" time="15.13" sysdate="23.12.2008" docs="64016" kind="P" /><u3 date="16.12.2008" time="15.06" sysdate="16.12.2008" docs="63815" kind="P" /><u4 date="09.12.2008" time="15.48" sysdate="09.12.2008" docs="63595" kind="P" /><u5 date="02.12.2008" time="15.18" sysdate="02.12.2008" docs="63471" kind="P" /><u6 date="25.11.2008" time="15.21" sysdate="25.11.2008" docs="63270" kind="P" /><u7 date="18.11.2008" time="15.12" sysdate="18.11.2008" docs="63025" kind="P" /><u8 date="11.11.2008" time="15.04" sysdate="11.11.2008" docs="62864" kind="P" /><u9 date="05.11.2008" time="17.44" sysdate="05.11.2008" docs="62769" kind="P" /><u10 date="28.10.2008" time="15.00" sysdate="28.10.2008" docs="62522" kind="P" />
</updates>
</QUEST>
</ib>
</user_info>

в таблицу попадают данные только до </PBI> дальше не вставляются..
я в xml и в MS SQL новичок.. объясните пожалуйста что к чему.. в чем проблема...

хранимая процедура:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spARB](@xmlDoc text)
AS
BEGIN
DECLARE @docHandle int
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDoc

-- Execute a SELECT statement using OPENXML rowset provider.
insert into dbo.usr_cons
SELECT *
FROM
OPENXML (@docHandle, '/user_info', 2)
WITH ( usr_file_date varchar (50) '//USR_FILE/@date',
usr_file_time varchar (50) '//USR_FILE/@time',
usr_file_kind varchar (50) '//USR_FILE/@kind',
info_cod_date varchar (50) '//info.cod/@date',
info_cod_time varchar (50) '//info.cod/@time',
consult_tor_date varchar (50) '//consult.tor/@date',
consult_tor_time varchar (50) '//consult.tor/@time',

vDistr varchar (50) '//@directory',
nDistr varchar (50) '//@nDistr',
nComp int '//@nComp',
directory varchar (50) '//@directory',
nCat int '//@nCat',
nTexts int '//@nTexts',
n3 int '//@n3',
n4 int '//@n4',
n5 int '//@n5',
n6 int '//@n6',
compliance varchar (50) '//@compliance',

u1_date varchar (50) '//u1/@date',
u1_time varchar (50) '//u1/@time',
u1_sysdate varchar (50) '//u1/@sysdate',
u1_docs int '//u1/@docs',
u1_kind varchar (10) '//u1/@kind',
u2_date varchar (50) '//u2/@date',
u2_time varchar (50) '//u2/@time',
u2_sysdate varchar (50)'//u2/@sysdate',
u2_docs int '//u2/@docs',
u2_kind varchar (10)'//u2/@kind',
u3_date varchar (50) '//u3/@date',
u3_time varchar (50) '//u3/@time',
u3_sysdate varchar (50) '//u3/@sysdate',
u3_docs int'//u3/@docs',
u3_kind varchar (10)'//u3/@kind',
u4_date varchar (50) '//u4/@date',
u4_time varchar (50) '//u4/@time',
u4_sysdate varchar (50) '//u4/@sysdate',
u4_docs int'//u4/@docs',
u4_kind varchar (10)'//u4/@kind',
u5_date varchar (50) '//u5/@date',
u5_time varchar (50) '//u5/@time',
u5_sysdate varchar (50) '//u5/@sysdate',
u5_docs int'//u5/@docs',
u5_kind varchar (10)'//u5/@kind',
u6_date varchar (50) '//u6/@date',
u6_time varchar (50) '//u6/@time',
u6_sysdate varchar (50)'//u6/@sysdate',
u6_docs int'//u6/@docs',
u6_kind varchar (10)'//u6/@kind',
u7_date varchar (50) '//u7/@date',
u7_time varchar (50) '//u7/@time',
u7_sysdate varchar (50) '//u7/@sysdate',
u7_docs int'//u7/@docs',
u7_kind varchar (10)'//u7/@kind',
u8_date varchar (50) '//u8/@date',
u8_time varchar (50) '//u8/@time',
u8_sysdate varchar (50)'//u8/@sysdate',
u8_docs int'//u8/@docs',
u8_kind varchar (10)'//u8/@kind',
u9_date varchar (50) '//u9/@date',
u9_time varchar (50) '//u9/@time',
u9_sysdate varchar (50) '//u9/@sysdate',
u9_docs int '//u9/@docs',
u9_kind varchar (10) '//u9/@kind',
u10_date varchar (50) '//u10/@date',
u10_time varchar (50) '//u10/@time',
u10_sysdate varchar (50) '//u10/@sysdate',
u10_docs int'//u10/@docs',
u10_kind varchar (10)'//u10/@kind')
EXEC sp_xml_removedocument @docHandle
END