Exporting SSIS packages

Beginning in DWD 11.3.01 HF22, Export SSIS Package feature enables users to export SSIS packages to a local server. Users can view, edit, and run SSIS packages in their local environment.

Export SSIS will have different requirements and captions depending on the SSIS deployment type. For MSDB, it is exported as Package. For SSISDB, it is exported as Project.

Open DWD, click DWD Solution tab > Maintenance Tasks > Export SSIS label. All compiled objects are automatically selected for export.

Optionally, you can right-click a compiled object and select Export SSIS label. Only the compiled object is selected for export.

The menu label shown will depend on the deployment type:


Deployment type	Label shown
MSDB	Export SSIS Package
SSISDB	Export SSIS Project

Specify the destination folder where the package will be saved.

Note: The destination folder path must not have spaces in between.

Optionally, you can select a Data Source System. By default, All Systems are selected.

If the compilation type is MSDB, you must select a protection level.

This table shows the different protection levels:


Protection level	Description
Do not save sensitive data	Sensitive information is not included in the XML file of the SSIS package.
Encrypt sensitive data with password	Users must specify a password when opening the SSIS package. Encrypt and decrypt sensitive information with a password.
Encrypt all with password	Encrypt the entire contents of the SSIS package with the specified password.

Specify a password. The default password is the export date of the package. Date format is DDMMYYYY.

To start exporting the SSIS package, click OK.