Forum Discussion
Help Needed: PowerShell Script Not Functioning Correctly When Run Via SQL Server Agent
Hello, I am facing an issue with a PowerShell script that is critical for our data operations. This script successfully retrieves data from an API and loads it into a SQL database when executed manu...
Hello.
I got a similar problem and I have fixed it by setting the sql agent job step as Command line to call a .ps1 file located on the file system
Regards
Javier
I got a similar problem and I have fixed it by setting the sql agent job step as Command line to call a .ps1 file located on the file system
Regards
Javier
Javier_Villegas Thank you for your reply. In my setup I call the script as part of a SSIS-package and it is not feasible to run the script directly as a commandline call in the SQL server agent.