This tool you reference looks very promising :). I haven't yet tried to install it but if it works then no more messy external PowerShell files to deal with. At least that is the way I understand it. Thank!
SSIS is much like PowerShell in that it too can be seen as a thin veneer on top of .NET. SSIS has many functions that make it easy to get data into and out of SQL Server, all of which are implemented in .NET. There is a very slick add-on for SSIS that allows you to code script components in PowerShell, a very handy tool that I have used. http://www.youdidwhatwithtsql.com/powershell-script-task-for-ssis/488
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))