I prefer to store our SSIS packages in a solution on the server rather than in sql. By default, sensitive data is encrypted using a user key. Since the sql server agent uses the service account to run jobs, we must change this encryption method to something else. I like password encryption.
The problem is that whenever I set the task to a step, there is no place to enter this password. When I click on the configuration tab, I get a pop-up dialog for the password. This stores it correctly, but it is really a good place to place it. This seems very unusual, and I continue to run into problems when it seems to reset itself if I make certain changes.
Does anyone know a better place to enter a more stable password?
Thanks,
source
share