Jeanne Combrinck shows us how to execute Powershell code from within SQL Server Integration Services:
It can be confusing to know which tool in the SSIS toolbox to use when trying to execute a PowerShell script from within SSIS.
The best task to use is an Execute Process Task.
Read on for an example.