Forum Discussion

German_Lagomarsino's avatar
German_Lagomarsino
Copper Contributor
Sep 20, 2024

Powershell script running in SQL task

Hi, what I need to do is to be able to run a powershell script from a sql task. This script contains secrets that were saved with a specific user account, this is necessary since the script makes connections to the Internet and must be authenticated. From a Windows scheduled task I managed to get it to work but not from a SQL task. Is there something that needs to be taken into account for this to work??

Thank you very much!

3 Replies

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    What for a "SQL Task" do you mean?
    One in a SSIS package?
    Sorry, simply to less on informations to guess anything.
    • German_Lagomarsino's avatar
      German_Lagomarsino
      Copper Contributor

      olafhelper 

      I am referring to an agent job, which runs a ps script. This script uses secret management and secret store to hide the connection passwords.

      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        That don't answer my question; you have to provide more details.

Resources