Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wagner Jo
Starting Member
2 Posts |
 Posted - 2012-03-27 : 05:39:51
|
| Hi,i have a problem with the execute Process Task. I wrote a Powershell Script that works fine, for it self.When I put it into a process task the script was not executed but the task did not fail. At the first step, i modified the rigths on the script and all directories, so that everbody has full control to them. But nothing changes. The script takes a file as input, modifies the data an writes back the modified data to a new file. SQL Server 2008 R2 is in use.Thanks for your help.Jo |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-03-27 : 12:13:40
|
| 1. is powershell installed on server at hand?2. might you need to preface the command with "powershell.exe script.ps1"?3. Is running powershell scripts enabled on server<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
Wagner Jo
Starting Member
2 Posts |
Posted - 2012-03-28 : 04:58:13
|
| Hi yosiasz,thank you for your help.I checked your Issues:1. Powershell is installed3. Yes execution is enabled2. The powershell script that has to be executed needs an additional parameter. Because i failed to put it into the task, I converted the script to an executable (exe). Have you any hints for my, how i can get both parameters (the script, that powershell has to execute and the parameter that the script needs) into the task?Thanks Jo |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-03-28 : 14:06:40
|
| unless your parms are static, you could try using expressions to dynamically build your whole statement with your parameters.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
|
|
Execute Process Task