search

TheDataShed / sql-deployment-tools

GNU General Public License v3.0
2 stars 0 forks source link

SSIS Variable Sensitivity #30

Closed gvee-uk closed 2 years ago

gvee-uk commented 2 years ago

The ability to mark SSIS environment variables as sensitive previously existed in an old version of this solution, but is no longer present.

This was pulled out because it was hitting a not-so-memorable issue that occurred either:

  1. on deployment
  2. on execution of the SSIS package(s) [via SQL Agent?]

So, I guess what I'm saying is, adding this back in should be trivial, but you have to prove that it works correctly post-deployment!

gvee-uk commented 2 years ago

Not entirely sure what the previous error was. I've tweaked the [obviously] incorrect code (see PR #45) and this appears to "just work".