G'Day,
只是想知道是否有人使用环境变量在同一台服务器上配置Dev,QAT和Production环境?
Just wondering if anyone has used Environment Variables to configure Dev, QAT and Production environments on the same server?
如果将环境隔离到自己的文件夹中,我可以看到这个工作。但不是通过具有三个环境设置的单个文件夹。除非项目部署的名称不同,即
I can see this working if a segregate environments into their own folders. But not by having a single folder with three environmental settings. Unless the project is deployed with different names i.e.
Visual Studio项目:安德鲁斯SSIS
Visual Studio Project : Andrews SSIS
部署三次
安德鲁斯SSIS开发
安德鲁斯SSIS QAT
安德鲁斯SSIS Prod
即
但开箱即用,项目名称无法修改。
But out of the box, the project name cannot be modified.
但是我可以看到这个结构有效:
However I can see this structure working:
Andrew
推荐答案
嗨Andrew,
Hi Andrew,
是的,您可以在/不在同一个文件夹中创建多个环境。
Yes, you can create several Environments in/not in the same folder.
乙ut,对于给定的执行,包只能使用单个服务器环境中包含的值执行。
请参阅: 创建并映射服务器环境
See:Create and Map a Server Environment
您可以将环境变量映射到参数,特定包,入口点包或给定项目中的所有包。  ;
有关如何使用环境的详细信息,请查看以下链接:
For the details about how to use Environments, please check this link:
SQL Server Integration Services中的设置环境变量
Setup Environment Variables in SQL Server Integration Services
更多推荐
SSIS单服务器多个环境和环境变量
发布评论