Using SSIS Execute Process Task to run an executable on a remote server

• sadcock2002

  SSC Enthusiast

  Points: 167

  More actions

  November 20, 2008 at 11:46 am

  #128834

  I am trying to use an execute process task to run a PERL script on a remote server. The PERL program, the PERL script, and the data files that are processed are all on the remote server but there is no sql installation on the remote server so the ssis package is running locally.

  When I run the task, a cmd window opens and the output written by the PERL script appears but the files that are supposed to be changed by the script are not changed. I get an error: Error: 0xC0029151 at Use Perl to Merge Worksheets, Execute Process Task: In Executing "\\8500b\c$\Perl\bin\Perl.exe" "\\8500b\d$\BusinessAnalyticsFiles\PerlScripts\Merge_4_Ford_DataLoad_files.pl" at "\\8500b\c$\Perl\bin", The process exit code was "9" while the expected was "0".

  Task failed: Use Perl to Merge Worksheets.

  Here is a screen shot of the process as I have it set up:

  

  What am I doing wrong?

• LOOKUP_BI-756009

  SSCertifiable

  Points: 7286

  More actions

  November 20, 2008 at 1:19 pm

  #901262

  Have you tried enable logging on your SSIS packages.You might be able to find some information in the logs.