I want to pass BCP commands from a SP to be executed by a powershell script.
Thanks for your contribution!
In a SQL agent job, T-SQL step that processes a stored procedure. From that SP do I execute a Powershell script as:
set @CmdPowershell ='Powershell -file '+char(34)+'\\SRVqwert\SWIDEN\PS_script.ps1'+char(34)
EXEC @rc =MASTER..xp_cmdshell @CmdPowershell
if @rc != 0
I have issues with error "must be digitally sign". I don´t know how to go further.
xp_cmdshell is used just to reach Powershell. Any way to avoid xp_cmdshell? How much security risk is xp_cmdshell?, impossible question but..
19 People are following this question.