Creating and saving packages in SQL Server Integration Services Database (SSISDB)

The SSISDB catalog is the central point in working with Integration Services (SSIS) projects deployed to the Integration Services server. In SSMS, it is under the Integration Services Catalogs node that contains the DWDFOLDER and DWDPROJECT, both created by DWD.

Select this option to create and save SSIS packages in SSISDB.

  1. From the DWD menu bar, select Compile > Compile Options.
  2. Select Save SSIS package in SSISDB.
  3. Specify Logging Level:
    None
    Captures information if the package succeeded or failed. Use this login if the performance of SSIS packages is important.
    Basic
    The default logging level recommended for everyday use. This login captures important events like errors and warnings as well as progress information.
    Performance
    Captures events internally to analyze the performance of the data flow components. This login is best used when performing benchmarking and performance tuning.
    Verbose
    Captures all log events including performance and diagnostic events especially when using OLEDB connections. This login should be used when trying to debug or diagnose package failures.
  4. Click OK.
  5. Compile the objects. Recompile if objects are already compiled.
    Note: 

    In SQL server, if clr enabled is turned off, an error message will appear during compilation. To troubleshoot, go to Compilation Options and select the Save SSIS package in SSISDB option again.

    If Save SSIS package in SSISDBoption is not selected, the SSIS packages are saved in MSDB. SSIS package in MSDB will not be deleted.

    This option is available in SQL version 2014 and higher.