How to call SQLPS from TSql in SQL Server 2008

Question

I see lots of examples on running SQLPS from SQL Server Agent, but how do you call a powershell script from TSQL on demand?

I'm replacing a C# CLR function with a PowerShell script. The script will simply get a path and date modified for files in a directory structure.

What's the command to call a PowerShell script from a T-SQL stored procedure?

CB. · Accepted Answer · 2011-10-17 17:17:31Z

1

Something like this:

set @sql = 'powershell.exe -file "YourScript.ps1" -nologo'

EXEC xp_cmdshell @sql

answered Oct 17, 2011 at 17:17

CB.

61.3k9 gold badges171 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jester Over a year ago

Okay, that worked. Thanks. One more question. I am running the following code : 'powershell.exe (Get-Childitem G:\11764 -include . -recurse) | select LastWriteTime,Name,Directory' The problem is that when I pipe it to the select statement, it causes an error, saying that it isnt a proper command. I'm assuming that it is trying to pipe to a CMD command when it needs to be powershell. Anyway to fix that?

Jester Over a year ago

Nevermind, thanks for the help. I fixed that part myself. Just added double quotes.

Collectives™ on Stack Overflow

How to call SQLPS from TSql in SQL Server 2008

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related