3

I am working on jobs currently and when I want to deploy my project I am receiving the following error. I tried to check the DTSPath but I wasn't able to find it under the following path "go to regedit->HKEY_LOCAL_MACHINE->SOFTWARES and under Microsoft Sql Server in SSIS"

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)

Improve this question
6
  • 1
    Mine is at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SSIS\Setup\DTSPath for SQL Server 2016. Replace the 130 with the correct folder. Then make sure the (Default) value looks something like this: C:\Program Files\Microsoft SQL Server\130\DTS\ Commented Jun 3, 2019 at 16:28
  • When checking the regedit, I cannot find the path you are having.When I try to modify the Default value, I get the following error : "Error writing the value's new contents" Commented Jun 4, 2019 at 7:22
  • What version of SQL Server and SSIS do you have installed? Commented Jun 4, 2019 at 15:18
  • SQL Server 2016 Commented Jun 5, 2019 at 2:20
  • What's the furthest down this registry path that you see on your box? HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Microsoft SQL Server\130\Tools\Setup If you can see the \Setup folder at the end of the path, what does the Edition or EditionType say? Commented Jun 5, 2019 at 14:20

2 Answers 2

Reset to default
1

This solved my problem immediately: http://thesqlgirl.com/2017/10/25/ssis-error-the-path-for-isserverexec-exe-cannot-be-found/

When I re-ran the SQL Installer and selected the instance I was having trouble with, I found that SSIS (Integration Services) wasn't installed, just like the article above suggested. Somehow, when I had removed a secondary instance of SQL that was running on same server, it affected other instances.

Not shocking for a Microsoft product.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

SQL Server 2022

After Uninstalling named Sql Server Instances from the server I got the same error.

enter image description here

Reason of the problem
SSIS is a common feature of Sql Server not an instance feature. The related utilities located in the folder of
"C:\Program Files\Microsoft SQL Server\160\DTS\Binn"
for SQL Server 2022

enter image description here

For the common feature reason uninstalling an instance, uninstalls the SSIS related utilities by mistake.

Solution of the problem

You need to re add the SSIS feature to the Sql Server.

To do this go to Program and Features> Uninstall/Change> it is simple but adding a feature to an Sql Server is not a daily routine. So you might forget.

enter image description here

Select Install media, then Add option from Install window.

enter image description here

Thick Integration services and finish the installation step by step.

enter image description here

After installing run the SSIS Job.

Registry Info for the SSIS Utility.

"C:\Program Files\Microsoft SQL Server\160\DTS\"

As we see from the following picture \Binn folder name not included.

enter image description here

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.