THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

XMLPad – a new tool in my developer utility belt

Yesterday I was on the lookout for a free tool that would help me write XPath statements. I put a shout out on Twitter and Johan Barnard replied saying :

Give XMLPad a try


I’m sure there are legions of developers out there that know all about XMLPad but I had never heard about it so I suspect some of you reading haven’t either. Today I downloaded it to give it a run out and I gotta say – I love it. I only used it to do one thing –constructing an XPath expression to point to a particular Configuration definition in a .dtsx file- and it allowed me to do that with consummate ease. The feature I particularly loved was that, similar to Google Suggest, it showed me results from my expression as I typed.

Here is a screenshot of my XPath expression to find (and just try saying this in a hurry)

the value of a property whose DTS:Name attribute equals ‘ConfigurationString’ of a Configuration definition where the value of that Configuration definition’s property whose DTS:Name attribute equals ‘ObjectName’, equals ‘BIConfig

Evaluate XPath in XMLPad

My XPath expression:


and believe me, there was no way I would have been able to come up with that without a tool to help me!

So, an easy tip for you – if you need to write XPath expression download XMLPad for free from and see what it can do for you.

That’s all. Its now Friday evening and I’m shutting down and relaxing before heading to the big game at Twickenham tomorrow (yes, I have a ticket Smile ). Have a good one!


Published Friday, February 11, 2011 8:22 PM by jamiet
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



AmosFiveSix said:

It's a great little tool. I use it for exactly the same thing.

February 14, 2011 9:22 AM

SSIS Junkie said:

Publish profile files are a new feature of SSDT database projects that enable you to package up all environment-specific

December 10, 2012 8:42 AM

Leave a Comment


This Blog


Privacy Statement