Powershell from SSIS

Copper Contributor

I am attempting to run a simple Powershell command through SSIS. The caveat is that I am using Posh-SSH as an add-on module. The Powershell script connects to a server via SSH, runs a command and captures the results. It works fine when I run it manually in Powershell or from the command prompt. When I run it through SSIS, I get this error:

Error: The 'New-SSHSession' command was found in the module 'Posh-SSH', but the module could not be loaded. For more information, run 'Import-Module Posh-SSH'..

I am running this in Visual Studio, so it is executing under my account. Does anyone have any idea why the Powershell configuration would be different in Visual Studio vs power shell prompt?

I have tried using

  • Cozy Roc Powershell task
  • TaskFactory Powershell task
  • Execute Process Task

Thank you in advance

0 Replies