PowerShell CommandNotFoundException error

Question

Greetings!!!

I'm trying to execute an SSIS package from Azure Data Factory and run into PowerShell CommandNotFoundException error. Everything works as expected when I run the package from my machine. When run on Azure Data Factory I get the below error.

Error:

The term   '\\storacc.file.core.windows.net\psscript\Test.ps1' is not recognized as the name of a cmdlet,   
function, script file, or operable program. Check the spelling of the name, or if a path was   included, verify that the path is correct and try again.  
CategoryInfo          : ObjectNotFound: (\\storacc...Test.ps1:String) [], CommandNotFoundException      +   
FullyQualifiedErrorId : CommandNotFoundException   

The powershell script path is in Azure Fileshare ('\storacc.file.core.windows.net\psscript\Test.ps1').

Thank you

Answer 1

Hi there,

This issue usually means the data source or destination is inaccessible from the SSIS integration runtime. The reasons can vary. Try these actions:

-Make sure you're passing the data source or destination name/IP correctly.
-Make sure the firewall is set properly.
-Make sure your virtual network is configured properly if your data source or destination is on-premises

I hope this information helps. If you have any questions please let me know and I will be glad to help you out.

-----------------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept it as an answer--