Integration services catalog setup

This step is necessary for brand new, unused SQL Server installations, where we want to deploy SSIS packages. When logged in to the server with SSMS, we simply right-click on the Integration Services Catalogs folder and choose Create Catalog...

The Create Catalog window appears. We fill in the properties and click on OK to create the integration services catalog:

Next, we'll create a folder for our project. In the Object Explorer, expand the Integration Services Catalogs node, right-click on SSISDB, and choose Create Folder... from the contextual menu that appears:

The Create Folder window appears. Set the properties to something similar to those shown in the following screenshot, and click on OK:

We're now ready to open the solution in Visual Studio. From there, we'll deploy it to our newly created on-premises Integration Services Catalogs folder.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset