Backup SSIS Package

0
votes

I want to backup SSIS package that already deploy. First I login to SQL Server Management Studio. Then click Integration Services Catalog then click SSISDB then right click on name project, then click export. After finished, there is no sln file. How to fix this problem?

enter image description here

1
sql-serverssisetl

1 Answers

0
votes

If you truely are trying to "BACKUP" SSIS packages, then you should only backup the following two things:

  1. Backup SSISDB database just like any other database
  2. Backup the Master encryption key for SSISDB.(Also keep save the password for SSISDB Master Encryption Key somewhere safe, you do need this while restoring SSIS Catalog)

You will need these two things to restore the SSISDB database.

Alternatively, if you are just trying to download SSIS packages from SSISDB, that have been already deployed, then you need to open Visual Studio, and create an SSIS project using template "Integration Services Import Project Wizard", this will allow you to connect to a server and download SSIS projects from SSISDB.