Formatting an SSIS Configuration File

Category : Blogs Published : April 19, 2013 User Rating : 4.5 Stars      Views : 3 Stars
One Click Feedback
Please help us to improve the site by rating the quality of this article by clicking a button below.




If you’ve ever used XML configuration files in your SSIS projects then you’ve probably noticed that that the file is formatted as one long string on a single line :
Unformatted SSIS Configuration File
This makes the file quite difficult to read and edit, especially if you need to edit it after deployment and only have notepad available to make changes. Fortunately this is very easy to resolve within BI Development Studio (BIDS), just open the configuration file (i.e. .dtsConfig) and press CTRL K followed by CTRL D. The XML file will then be displayed on multiple lines with appropriate indentation :
Formatted SSIS Configuration File

If you prefer using menus then this can also be done within the Edit menu. Just select Advanced and then select ‘Format Document’ from the dropdown menu.

One thing to note is that if you make any changes to the configuration within the Package Configurations Organizer then the file will revert back to the single line format, but you can reformat it again as above. Although formatting the files in this was is quite straightforward it’s surprising that this doesn’t occur automatically, however this behaviour occurs in BIDS for SQL Server 2005, 2008 and even 2012 (assuming you use the Package Deployment Model – configurations are usually handled differently in 2012).
Link back to this article : http://www.sqlmatters.com/Articles/Formatting an SSIS Configuration File.aspx

Keywords

SQL, BIDS, SSIS


Comments

Post a comment   No login required !

 
Name :   Email :   Website :  
Will be displayed alongside your comment
Not displayed Optional, but displayed if entered