I've been reading Matt Masson's article on how to read the value of a sensitive parameter in a C# script. However the script in question is in a package part, which does not seem to be able to access project parameters.
Does anyone has any ideas on how we could circumvent this?
Basically I created a C# script to send emails via SendGrid. Since I need to use this across multiple packages, in my SSIS project, I made it a Package Part where I can pass the message subject, body, etc via variables expression.
Things get complicated when we talk about Parameters though. I thought of using the SendGrid API KEY as a sensitive parameter. I cannot set it directly to a variable (i.e. via expression) because it is sensitive, and in the package part itself I cannot reference project parameters... Any ideas?