Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Move SSIS Catalogs - Environments

Author  Topic 

shan
Yak Posting Veteran

84 Posts

Posted - 2014-03-11 : 12:07:01
Is there a easy way to move \Script out the SSIS Environments (SSIS Catalogs) from one server to another?

I can move the SSIS projects (Packages) easily using "deploy_project" Stored proc, Wonder how to automate the environments \ variables move from one server to another.


-Shan

sz1
Aged Yak Warrior

555 Posts

Posted - 2014-03-24 : 11:58:30
You can set the variables at package or project level, if you are moving your projects to a new server holding area you will need to edit the .sln file to update the new location of the packages or they will fail.

If you will it you can achieve it!!
Go to Top of Page
   

- Advertisement -