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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.