运行时错误：包安装失败，已安装的依赖项已回滚

Question

我计划在SQLServerManagementStudio中执行python脚本，但首先我必须先安装一些缺少的库/包，以便脚本能够正常运行。我使用sqlmlutils在SQL Server中安装这些python包，但在运行以下脚本时似乎出现了错误：

import sqlmlutils
connection = sqlmlutils.ConnectionInfo(server="myserver", database="mydatabase", uid="myid", pwd="mypassword")
sqlmlutils.SQLPackageManager(connection).install("pandas-profiling")

这是我从Spyder控制台得到的错误：

Incorrect syntax near 'Python'. Traceback (most recent call last):

File "", line 1, in runfile('C:/Users/.../Desktop/abc.py', wdir='C:/Users/.../Desktop')

File "C:\ProgramData\Anaconda3\lib\site-packages\spyder\utils\site\sitecustomize.py", line 705, in runfile execfile(filename, namespace)

File "C:\ProgramData\Anaconda3\lib\site-packages\spyder\utils\site\sitecustomize.py", line 102, in execfile exec(compile(f.read(), filename, 'exec'), namespace)

File "C:/Users/.../Desktop/abc.py", line 3, in sqlmlutils.SQLPackageManager(connection).install("pandas_profiling")

File "C:\ProgramData\Anaconda3\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 74, in install self._install_from_pypi(package, upgrade, version, install_dependencies, scope, out_file=out_file)

File "C:\ProgramData\Anaconda3\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 151, in _install_from_pypi self._install_from_file(target_package_file, scope, upgrade, out_file=out_file)

File "C:\ProgramData\Anaconda3\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 174, in _install_from_file self._install_many(target_package_file, dependencies_to_install, scope, out_file=out_file)

File "C:\ProgramData\Anaconda3\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 189, in _install_many raise RuntimeError("Package installation failed, installed dependencies were rolled back.") from e

RuntimeError: Package installation failed, installed dependencies were rolled back.

请问这里有没有人犯过同样的错误？顺便说一下，我正在使用Sql Server 2017。非常感谢您的帮助