Andy Brownsword doesn’t just leave passwords in plaintext:
Configuring SSIS projects or packages can necessitate parametering information which may include sensitive values such as authentication details. Parameters are stored as plain text in the database by default. We’ll demonstrate how to protect these values using Sensitive parameters.
Read on to learn how to make an SSIS project parameter sensitive, as well as how to use them afterward.