SSIS Powershell

Question

我试图使用以下参数通过SSIS运行下面的Poweshell命令。

(get-content z:\2.html) | foreach-object {$_ -replace "><", ">`r`nE<"} | set-content z:\2.html

这在命令行的Powershell中可以工作，但我不能让它在SSIS中工作。

我知道错误了

at "", The process exit code was "1" while the expected was "0".

在SSIS中我有：

1. Created an "Execute process Task"
2. Pointed the Executable to system32\WIndowsPowershell .. etc
3. Added the argument as detailed above using a variable as the filename 

有什么想法吗？

Answer 1

似乎语法应该是..。

(get-content z:\3.html) | foreach-object {$_ -replace '><', '>`r`nE<'} | set-content z:\3.html

现在起作用了！