This article deals with the following

1. Setting up SQL SSISDB catalogue database
2. Writing a basic SSIS package
3. Deploying the package to a SQL Server

Setting up SQL SSISDB catalogue database

First of all you need to install this feature. Mount the SQL Server installation media, choose install and select the ‘integration services’ from the options. then complete the install and reboot your server.

Next, start up SSMS and create the Catalogue

The SSISDB database will now get created.

In the next part of this series, we will look at writing a basic SSIS package.