I develop a set of SSIS-packages with several variables. First, the package loads the database connection string from .dtsconfig file. Then, applies other variable values from database table. The purpose of the package is to load data from web-service and store it into the database.
The first problem may occur when moving to Q&A or Prod environments. In case of any problems with config-file, the package continues loading the data, using design time variables, and rewrites production data with records, loaded from development web-service.
The second problem is distribution. I don't want our customers to see any of our server names. Or other sensitive information.
Are there any means to remove the design-time values from SSIS package before deploying it anywhere?
I cannot protect the package with user key, as it is meant to be distributed. And it doesn't solve the first problem.
AFAIK, there is no way to declare the variable as sensitive (http://www.sqlservercentral.com/Forums/Topic1234330-364-1.aspx)
I'd like to make everything automatic. I can delete all values every time before saving the package, but this won't fit: someone will surely forget to do this.