How to deploy an ssis project with Project Variables Mappings to another server

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  April 17, 2020 at 3:17 pm

  #3743764

  I have a project already deployed to SSISDB on a server A. I have references to an environment as well as the project variable mappings inside the project already configured. I need to find the easiest way to deploy this to server B and retain the references and mappings. The person deploying doesn't know anything about SSIS. What is the easiest way to do this? It would be great if I could create a script that would create the project with its packages, references to environments, and project mappings to the environment variables as they currently are in server A but I havn't found a way to do this.

   

  Thanks,

  Dan

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  April 18, 2020 at 4:10 pm

  #3743936

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.