SSIS Variable and Parameter Analysis


Introduction

If you have an SSIS project that’s matured over time and makes good use of variables and parameters, you’re probably nervous about deleting any of them, even if you think that they are no longer in use. Wouldn’t it be great to be sure and then tidy things up with confidence?

I had one such project and decided to tackle the problem in code, after being unable to find anything already written which covers the same ground. BI Developer Extensions looked promising, but I found that it was buggy in this area. It suggested that some of my variables