Creating SSIS Catalog

  1. Open SQL Server Management Studio.
  2. Connect to SQL Server Database Engine.
  3. In Object Explorer, right-click Integration Services Catalogs and then click Create Catalog.
  4. Click Enable CLR Integration.
  5. Select Enable automatic execution of Integration Services stored procedure at SQL Server startup.
  6. Specify Password and then click OK.