InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 00:52:45 GMT20http://www.sqlservercentral.com/Forums/Topic724074-148-1.aspxHi could you (or someone else) please explain how to do that. Let's say I want to hidea specific property in one of my SSIS package components, for example a file path. How can I make sure this one is encrypted in my .dtsx file ?can someone please give some examples that takes me in the right direction....brHelmutMon, 01 Jun 2009 11:39:47 GMTHelmut Nielsenhttp://www.sqlservercentral.com/Forums/Topic724074-148-1.aspxYou can change the protection level on the dtsx package to Encrypt Sensitive Data with User Key but then you are on the only that open and maintain the package.Wed, 27 May 2009 08:31:35 GMTJustin Lezonhttp://www.sqlservercentral.com/Forums/Topic724074-148-1.aspxHiI would like to save the properties for my SSIS packages in the SQL server database. The main reason is that I have some file references set as properties for individual components in my SSIS packages, and when moving my project from one machine to another, I dont want to change settings in the package, instead just change some properties in a configuration table in SQL server. I started to look into the functionality present for saving the SSIS data as a "Package Configuration".....this seems to be working, if I change a setting for a property in the database table created for the configuration, this will be reflected during the execution of the SSIS package...BUT, from what I thought, the settings (properties) I choose to have included in the package configuration can still be seen in the .dtsx file....Really why I'm doing this in the first place is to be able to hide file references in my .dtsx file......I thought the .dtsx file should only have some sort of cryptic reference in that text file for the properties being read from the configuration table in the database.....doesnt seem to be the case...Have anyone any suggestion how to "hide" file references or other properties (like usernames etc) from the .dtsx file if someone opens this file.Help appreciated :-)Best RegardsHelmut NIelsenWed, 27 May 2009 07:33:48 GMTHelmut Nielsen