First of all I am new to ssis so sorry if this question is simple to answer.
I open sql management studio 2014, and connect to my sqlserver. Secondly I connect to my integration services.
Now I have an .ispac file that needs a catalog in my integration services. However I do not have a catalog in my integration services all I have is the following:
How do I add a catalog and deploy my .ispac file to this catalog?
Clarification:
I have 2 servers: 1 crm server and 1 sql server. I have no direct access to the sql server, to connect to the database I use sql management studio 2012.
On the crm server the integration services are installed. I add these to the sql management studio using the connect button (see picture)
I have a deployment file (.ispac) but in order to deploy this I need a catalog. However on the Integration Services that have been added in the sql studio it is not possible to add a catalog. It only has MSDB and I need SSISDB.
How can I deploy my deployment file?
