我正在尝试从SSIS Execute Process任务中执行Python脚本。我按照所有教程的步骤进行操作,但脚本仍然从一开始就失败了。当我在SSIS之外执行Python脚本时,它可以完美运行。
这是我的Python脚本:
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")
这是 SSIS 执行进程任务的图片:
错误信息:
[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".
import sys
前的空格是个问题,除非只是在贴代码到 SO 上时出现的。 - Cleared