如何将 ssis 包从 Dev 转移到 Prod? [英] How to transfer a ssis package from Dev to Prod?

问题描述

我正在尝试使用配置文件将我的包移动到生产环境中，但文件只更改了一部分，结果仍然发送到 DEV 服务器.

I'm trying to move my packages to production using a configuration file, but file is changed only partly and the results go still to DEV server.

有人知道该怎么做吗?

推荐答案

如果不访问您的配置文件，就很难找出问题的原因.

It is difficult to isolate the cause of your issues without access to your configuration files.

我建议您使用在您的环境中引用数据库的包配置.然后可以使用每个环境唯一的环境变量来引用数据库本身.

What I suggest you do is make use of package configurations that reference a database within your environment. The databases themselves can then be referenced using environment variables that are unique to each environment.

这是一个很好的节省时间的方法，也是集中管理所有 SSIS 包配置的好方法.详情请看以下参考资料.

This a brilliant time saver and a good way to centrally manage the configuration of all your SSIS packages. Take a look at the following reference for details.

http://www.mssqltips.com/tip.asp?tip=1405

配置后，您可以在开发和生产之间部署相同的相同包，而无需对 SSIS 包进行任何修改或处理配置文件.

Once configured, you can deploy the same identical package between dev and production without needing to apply a single modification to the SSIS package or mess around with configuration files.

这篇关于如何将 ssis 包从 Dev 转移到 Prod?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！