Forum Discussion
German_Lagomarsino
Sep 20, 2024Copper Contributor
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
- olafhelperBronze ContributorWhat for a "SQL Task" do you mean?
One in a SSIS package?
Sorry, simply to less on informations to guess anything.- German_LagomarsinoCopper Contributor
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.
- olafhelperBronze ContributorThat don't answer my question; you have to provide more details.