sql-server - 要在 SQL Server Data Tools 之外运行 SSIS 包，您必须安装 Integration Services 标准版或更高版本

Question

我正在尝试从批处理文件中运行 SSIS 程序包，但出现错误

To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.

但在 Visual Studio 中我可以成功执行。我的批处理文件中的代码

set DtexecFileLoc=C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\Dtexec.exe

::@echo Batch File Loc: %BatFileLoc%
@echo SSIS Package Location: %SSISPkgLoc%
echo.

@echo Please enter the variable values for which you want to refresh DEV environment.
set /p EffDate=Enter the Month-End EffectiveDate in MM/DD/YYYY format:%=%


@echo SSIS Package is going to run for EffectiveDate '%EffDate%' . 
@echo If these variable values are not correct then close the window and re-run the batch file again.
@echo DO NOT CLOSE this window while the SSIS Package is running.
echo. 
pause 

"%DtexecFileLoc%" /File "%SSISPkgLoc%" /SET \Package.Variables[User::z_Dest_ServerName].Properties[Value];"%DestServer%" /SET \Package.Variables[User::Z_Dest_UserName].Properties[Value];"%DestUserName%" /SET \Package.Variables[User::Z_Dest_Password].Properties[Value];"%DestPassword%" /SET \Package.Variables[User::z_Email_Server].Properties[Value];"%EmailServer%" /SET \Package.Variables[User::z_Source_ServerName].Properties[Value];"%SourceServer%" /SET \Package.Variables[User::Z_Source_Username].Properties[Value];"%SourceUserName%" /SET \Package.Variables[User::Z_Source_Password].Properties[Value];"%SourcePassword%" /SET \Package.Variables[User::z_Email_Recipient].Properties[Value];"%EmailRecipient%" /SET \Package.Variables[User::y_EffectiveDate].Properties[Value];"%EffDate%"  > "%SSISLogLoc%"


@echo SSIS Package execution is now complete, you can now close this window.
echo. 
pause

这是我的环境配置

我已经尝试为可执行文件切换不同的路径，但它在我的情况下不起作用。这是我的日志这里是错误消息下面的日志文件

Microsoft (R) SQL Server Execute Package Utility Version 14.0.3026.27 for 32-bit Copyright (C) 2017 Microsoft. All rights reserved.

Error: 2019-12-11 15:47:30.29 Code: 0xC000F427 Source: Update ErrorList Description: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher. End Error

Answer 1

要检查的内容:

• 确保您已从 SQL Server 安装中安装了 SQL Server Integration Services(而非 SSDT)(确保它已在功能列表中选中)。
• 如果安装了 SSIS，请确保 Integration Services 服务正在运行
• 如果服务正在运行，请确保您创建的包的 TargetServerVersion 与安装的 SQL Server 版本匹配

有用的链接

• A Tale of Two Properties: SSIS ProjectVersion and TargetServerVersion
• Install Integration Services (SSIS)
• Integration Services Service (SSIS Service)