I 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 :-)