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 con...
olafhelper
Sep 25, 2024Bronze Contributor
What for a "SQL Task" do you mean?
One in a SSIS package?
Sorry, simply to less on informations to guess anything.
One in a SSIS package?
Sorry, simply to less on informations to guess anything.
German_Lagomarsino
Sep 25, 2024Copper 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.
- olafhelperSep 26, 2024Bronze ContributorThat don't answer my question; you have to provide more details.