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.
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!! |
|
|
|
|
|