Some useful info for tracking the results of PPSCMD.exe into a log file.
Your post did point me in the right direction. However, there are two parts to a workable solution:
1) There is the *undocumented feature* for ppscmd which is using custom handle 3 for output (instead of stdout which is handle 1) so you have to use 3>&1 in you command argument. I was lucky, I guessed...
2) To implement a redirect in SSIS Execute Process task you have to use a workaround using cmd /C as your executable.
http://blogs.msdn.com/michen/archive/2007/08/02/redirecting-output-of-execute-process-task.aspx
Put together, it willl look something like cmd /c ppscmd [arguments] 3>&1 >> mylog.txt.
No comments:
Post a Comment