Post reply

SSIS Project Deploy issues

  • November 7, 2014 at 9:28 am

    #397619

    Dear experts,

    I have a weird issue with project deployment on SSIS catalog. (2012)

    I have deployed 4 projects using different methods before:

    - using SSDT right click deploy

    - using Deployment Wizard

    - using a procedure which calls SSISDB.catalog.deploy_project

    Everything is on DEV for the moment.

    Now I want to deploy another project on DEV but none of the 3 methods (which basically use deployment wizard) works. I get the next error:

    Msg 27108, Level 16, State 1, Line 1

    The path for 'ISServerExec.exe' cannot be found. The operation will now exit.

    Msg 6522, Level 16, State 1, Procedure deploy_project_internal, Line 0

    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.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)

    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

    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)

    .

    Thanks,

    Marius

  • November 7, 2014 at 1:15 pm

    #1757252

    after a lot of hours i found out it was because of a path in regedit.

    so if you have a similar problem is good to check this: go to regedit->HKEY_LOCAL_MACHINE->SOFTWARE and under Microsoft Sql Server in SSIS make sure that DTSPath is correct (for me it didn't work because it was missing a \ at the end of path: c:\Program Files (x86)\Microsoft SQL Server\110\DTS - not correct)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply