question

sunil2711 avatar image
sunil2711 asked

XML Config

Hi All, I created the XML configuration file for SSIS package, In that selected the properties server name,initialcatalog and password for one of the connection string. After that entered the password value instead of string(text) in xml file and save it back.Here my question is when I open the XML file (after the changes in password string) the password(That I replaced with string) appear as a plain text but not encrypted. How can I encrypt the password value in XML Confog File.
ssisconfiguration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Bjhtech avatar image
Bjhtech answered
Hi, As far as I know, there is no way of encrypting the XML Config. Jamie Thomson (SSIS Junkie) blogged about the same topic some years ago and I don't think the solution has changed - http://consultingblogs.emc.com/jamiethomson/archive/2007/04/26/SSIS_3A00_-Storing-passwords.aspx - as he states, the common solution is to lock down the share/folder where the XML Config will reside. Barry
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.