SSIS:如何使用单个程序包配置文件使用Deployment Utility

时间:2022-02-23 23:06:13

I am trying to create a deployment utility for a solution using a single package configuration file shared across packages.
when I try to build the solution to create the deployment utility, the build process fails saying that the package configuration file already exists....

我正在尝试使用跨包共享的单个包配置文件为解决方案创建部署实用程序。当我尝试构建解决方案来创建部署实用程序时,构建过程失败,说包配置文件已经存在....

Any ideas

1 个解决方案

#1


Is there an option to overwrite that file? There are similar settings in Reporting services concerning datasources...

是否有覆盖该文件的选项? Reporting Services中有关于数据源的类似设置......

Don't know about that though - we set an env variable on the server which points to the sql instance with the ssis config db and then the package finds the ssis configurations database in that instance.

虽然不知道 - 我们在服务器上设置了一个env变量,该变量使用ssis config db指向sql实例,然后包找到该实例中的ssis配置数据库。

#1


Is there an option to overwrite that file? There are similar settings in Reporting services concerning datasources...

是否有覆盖该文件的选项? Reporting Services中有关于数据源的类似设置......

Don't know about that though - we set an env variable on the server which points to the sql instance with the ssis config db and then the package finds the ssis configurations database in that instance.

虽然不知道 - 我们在服务器上设置了一个env变量,该变量使用ssis config db指向sql实例,然后包找到该实例中的ssis配置数据库。