Dear LutzM

Thanks for your responce:)

yes, when I select and click on the column it does open the complete XML file in a new window. (while I want to store...

Dear Jeff

I have sueccessfully loaded xml files in all sub folders of the main directory.

Next, I am using OPENXML to view the contents of the each XML file(by using...

Hi

Many thakns for your reply:)

yes I can use xp_CmdShell or sp_OACreate.

No I am not restricted to T-SQL solution. Actually I dnt know much about SSIS. I did serach about it...

Hello Jeff

Your Single line of code has helped me alot!

Actually what I am trying to do is loop through all the subdirectories under a root folder and load the files...