CODEWITHSUNDEEP
sqlsql-serverdeploymentssisprojects
user2315732
user2315732

Reputation: 365

Not able to Deploy the SSIS Project to SQL Server

I have installed integration services without any issues but not able to deploy the SSIS projects to SQL Server, If I try to connect integration services using object explorer I can connect without any issues.

I have given the permissions to the users on Integration services using Dcomcnfg.exe.

Please help me to resolve the deploying issue at the earliest.

Upvotes: 3

Views: 8638

Answers (1)

billinkc
billinkc

Reputation: 61269

You do not have SQL Server Integration Services Service installed. Locate your installation media and walk through the install and select the Integration Services component.

You can verify installation was successful by shelling to the command prompt and typing dtutil.exe. Once it stops reporting this error message, the install is valid

one of the components: Integration Services, Management Tools - Basic or Business Intelligence Development Studio has to be installed by the SQL Server 2012 Standard, Enterprise, Developer, or Evaluation Edition. To install a component, run SQL Server Setup and select the component name

Upvotes: 2

Related Questions