kevaburg (3/16/2015)
Grant Fritchey (3/16/2015)
I'd probably reverse build on this. If you need to manipulate files and do t-sql, I'd write it in PowerShell and call the T-SQL from there rather than trying to burst out to do PoSh from within the T-SQL.I hadn't thought of it from that angle....I will try it and post the results here.
Thanks!
Jeff has a good lead that may fix your immediate issue but long term I must give a +1 to shifting your approach towards what Grant described.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato