This article deals with the following
- Setting up SQL SSISDB catalogue database
- Writing a basic SSIS package
- 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.