Editing SSIS Package Configuration XML Files

Question

Post reply

Editing SSIS Package Configuration XML Files

Welsh Corgi

SSC Guru

Points: 116520
More actions
May 29, 2012 at 7:55 am

#150944

I tried editing an XML File by opening it in Notepad and I had to scroll a lot so that does not seem to be a good option.
I opened the XML File in SSMS but it was one line.
What is a good editor or what is the best way to edit the file? I tried using the wizard but that was a no go.
I noticed that for many attributes the values were stored inside the configured value.
Properties[ServerName]" ValueType="String"><ConfiguredValue>MyServer</ConfiguredValue></Configuration>
But some Properties such as User Name are not present as in this example:
Properties[UserName]" ValueType="String"><ConfiguredValue></ConfiguredValue>
So if I altered the following and added "MyLogin" I assume that this would change the login. Not that I would want to do it but does not the same go for password?
Properties[UserName]" ValueType="String"><ConfiguredValue>MyLogin</ConfiguredValue>
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

Welsh Corgi (5/29/2012)
I opened the XML File in SSMS but it was one line.

Press Ctrl+K+D to reformat the XML into something more readable.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

mohit_3454 SSC-Addicted Points: 431 More actions · Answer 3

You can probably use notepad++ to edit xml files (it's also useful for loads of other languages too).

Not sure why the username is not displayed betwwen the <ConfiguredValue> & </ConfiguredValue nodes (maybe ypu missed it while creating package configuration file) but the password is not displayed in config file by default. i.e. You will always have to manually enter it everytime.