Hello friends... ....I want to open XML File from particular path like ....EXEC sp_xml_preparedocument @iDoc output,'D:\012505_074138_00000004.zip/*.XML' ....here are 200 files might be present and i want only one ....field from each file. Roots in all files are same .... but i am getting error like ....Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 2 XML parsing error: Invalid at the top level of the document. ....what might be problem ....somebody please help me out thanks
|