1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Anuncie Aqui
    Anuncie aqui você Também: fdantas@4each.com.br

[Python] SSIS Execute Process Task Python script

Discussão em 'Python' iniciado por Stack, Julho 24, 2025.

  1. Stack

    Stack Membro Participativo

    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.

    This is my Python scrip:

    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")


    this is an image of the SSIS Execute Process Task:

    [​IMG]

    error message:

    [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".

    Continue reading...

Compartilhe esta Página