The T-SQL Script which will parse the XML file stored in the file system and retrieve the values and stored it in a local variable for usage in the code. Actually i had wrote this snippet of code to parse a .dtsconfig file of SQL Server 2005 Integration services. We can make use of this code to parse a well formed XML file also.