Enable Integration Services on a remote server

Viewed 23

I am attempting to deploy an SSIS package on a remote SQL Server by following the following tutorial. My issue is that the Integration Services Catalogs folder is empty and when I try to create a catalogue, I get the following error:

The path to the catalog backup file could not be determined.
Integration Services might not be installed on this server, or the user may not have the appropriate access permissions

Is it even possible to achieve my goal on a remote server or do I absolutely need access to the machine on which it is running on?

1 Answers

Once SSIS is installed on the server, you can create the SSIS catalog and deploy SSIS projects to the catalog remotely.

Related