CODEWITHSUNDEEP
sql-serverssisetl
Gareth
Gareth

Reputation: 35

Deploying ssis 2012 with visual studio 2010

I've created a new SSIS package in Visual Studio 2010 and started deploying the package to a SQL 2012 database on a remote server.

I can connect to the DB and see the SSISDB folder but when i deploy the package I get the following error:

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

Upvotes: 2

Views: 4343

Answers (1)

ToOsIK
ToOsIK

Reputation: 643

Are you sure you have SSIS 2012 installed on that machine? and the service is running? (check SQL Server Configuration Manager)

This looks like you created an SSIS catalog on a SQL Server machine that has no SSIS service running (or SQL is unable to see the correct version of SSIS running). You will be able to see the catalog and even go through the deployment wizard from visual studio, but will receive the error message you mentioned above when you finalize your deployment.

Upvotes: 1

Related Questions