title: SSIS Execute Process Task Python script
body: <p>I'm trying to execute a python scrip from SSIS Execute Process Task. I followed all the tutorials of how to do this an still the script is failing from the start. when i execute the python script out of SSIS it runs perfectly. </p>
  
  <p>This is my Python scrip:</p>
  
  <pre><code> import sys
  import gender_guesser.detector as gender
  import xml.etree.cElementTree as ET
  from xml.etree.ElementTree import ParseError
  try:
      input("Press Enter to continue...")
  except SyntaxError:
      pass
  tree = ET.parse('user.xml')
  
  root = tree.getroot()
  
  for child_of_root in root:
      for  attr in child_of_root:
          if attr.tag == 'first_name':
           upperName = "%s%s" % (attr.text[0].upper(), attr.text[1:])
           print attr.tag,upperName
           d = gender.Detector()
           gen = d.get_gender(upperName)
           print gen
      attr.text= gen
  
  tree = ET.ElementTree(root)
  tree.write("user1.xml")
  </code></pre>
  
  <p>this is an image of the SSIS Execute Process Task:</p>
  
  <p><a href="https://i.stack.imgur.com/b7EHd.png" rel="noreferrer"><img src="https://i.stack.imgur.com/b7EHd.png" alt="this is an image of the SSIS Execute Process Task"></a></p>
  
  <p>error message:</p>
  
  <pre><code>    [Execute Process Task] Error:
   In Executing "C:\Python27\python.exe" "C:\Users\bla\blalba\bla\gender-guesser-0.4.0\test\genderTest.py " at "", The process exit code was "1" while the expected was "0".
  </code></pre>