Making Your SSIS Configuration Files More Readable

15 April, 2010 (10:45) | SSIS, XML | By: Mark V

When you first create a configuration file in your Integration Services project, the XML contents of the file are just laid out in one long line. This makes reading and/or modifying this file more challenging than it needs to be.

There is an easy way to format your file to alleviate this issue. In BIDS, go to File/Open/File, as in the image below:

image

Browse to your configuration file and select it to open within BIDS.

My brand new configuration file looks like this image below:

image

You see that the contents are all on one line. Bleh.

To fix that, you can go to Edit/Advanced/Format Document, as shown below:

image

I have done that to my config file and now it looks like this:

image

As you can see, this is much easier to deal with. Just save this document and close it. Now, even when you open it in Notepad, that formatting persists.

image

This little trick can make dealing with your configurations files a bit easier.

Comments

Comment from stefbauer
Time April 15, 2010 at 11:44 am

Good points! You may also want to check-out bids-helper on codeplex. it has some good features (including the automatic formating of config files) http://bidshelper.codeplex.com/wikipage?title=dtsConfigFormatter&referringTitle=Home

Comment from Dan English
Time April 15, 2010 at 11:55 am

Nice. Hadn’t seen that option before. To just view the files in BIDS in the cleaner format you can just leverage BIDS Helper as well:) Another assume feature that is included…and it is all free thanks to CodePlex – http://bidshelper.codeplex.com/wikipage?title=dtsConfigFormatter&referringTitle=Home.

Pingback from Tweets that mention Making Your SSIS Configuration Files More Readable | Mark V SQL — Topsy.com
Time April 15, 2010 at 12:02 pm

[…] This post was mentioned on Twitter by PASSMN, Mark Vaillancourt. Mark Vaillancourt said: [BLOG] Making Your SSIS Configuration Files More Readable: http://bit.ly/cxILU2 #ssis #sqlhelp […]

Comment from Mark V
Time April 15, 2010 at 12:58 pm

I am just getting acquainted with BIDS Helper and had not seen that feature yet. Sweet. Thanks, gents.

Comment from Eric
Time April 16, 2010 at 12:46 am

K + D. Much quicker…

Comment from Eric
Time April 16, 2010 at 12:46 am

That is CONTROL K + CONTROL D. It stripped my last attempt. ;-)

Comment from Mark V
Time May 10, 2010 at 9:14 pm

Thanks much.

Comment from Amy
Time June 5, 2010 at 2:41 am

K + D. Much quicker…

Comment from Sid
Time February 13, 2014 at 9:30 am

Very nice bit..thanks

Comment from 台灣大樂透
Time September 20, 2014 at 8:08 pm

Awesome site, thank You !!

Comment from Daniel Adeniji
Time January 12, 2017 at 7:11 am

I am having an insomnia week. And, finally settled on actually watching something useful on YouTube. Thankful that I stumbled on the video titled Sql Saturday #332 Interviews at KFAI Radio. And, that led me to your Blog and furthermore to this video.

Sincere & Heartfelt Gratitude,

Daniel

Write a comment