Aaron Nelson (Blog | Twitter) and I have a little game we like to play where we drink beer and talk smack about each other’s favorite platform. I’m (mostly) an SSIS developer. He’s a (SQL Server) PowerShell guy. He’s always calling SSIS bloated and inferior, while my position is that PowerShell, while handy for many things, is just not suited for ETL work beyond straight-copy-data-pushes.
But today I found a PowerShell feature that I and all of my hard core ETL developer compadres can really get behind: the ability to script the creation of an Environment Variable.