stan.geiger (12/3/2015)
Personally I think executing Powershell scripts within SSIS sets a really bad precedent.
that's your opinion and you're entitled to it.
stan.geiger (12/3/2015)
There is probably a better solution. Just my opinion, but I would never allow it in my shop. Just because you can doesn't mean you should.
there may well be a better solution, the guide shows how to execute a posh script as this is something that I've seen issues with across many forums.
stan.geiger (12/3/2015)
SSIS is an ETL tool not a programming language.
no it's not a pure ETL tool, as mentioned already it's a process control tool
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉