sql-server - 部署项目时找不到 'ISServerExec.exe'的路径

Question

我目前正在做作业，当我想部署我的项目时，我收到了以下错误。我试图检查 DTSPath 但我无法在以下路径下找到它“转到 regedit->HKEY_LOCAL_MACHINE->SOFTWARES 并在 SSIS 中的 Microsoft Sql Server 下”

The path for 'ISServerExec.exe' cannot be found. The operation will now exit. A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": System.Data.SqlClient.SqlException: The path for 'ISServerExec.exe' cannot be found. The operation will now exit. System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages) at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource 1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteToPipe(SmiContext pipeContext) at Microsoft.SqlServer.Server.SqlPipe.ExecuteAndSend(SqlCommand command) at

Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.RaiseError(SysMessageId messageId, SysMessageSeverity severity, Object[] args) at Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName) . (Microsoft SQL Server, Error: 27108)

Answer 1

这立即解决了我的问题: http://thesqlgirl.com/2017/10/25/ssis-error-the-path-for-isserverexec-exe-cannot-be-found/

当我重新运行 SQL 安装程序并选择遇到问题的实例时，我发现没有安装 SSIS(集成服务)，就像上面的文章所建议的那样。不知何故，当我删除了在同一台服务器上运行的 SQL 的辅助实例时，它影响了其他实例。

对于 Microsoft 产品来说并不令人震惊。