SSIS-在整个项目中更改对变量/参数的引用 [英] SSIS - Changing references to a Variable/Parameter through all the project
问题描述
我已经创建了一个SSIS项目，认为它将以项目部署模式进行部署.
I've created an SSIS project, thinking it will be deployed in Project Deployment mode.
我的很多程序包都有2个参数(分别称为P_OdsTbl和P_SrcEtl)，每当我使用执行程序包任务时，我都会将子参数绑定到父参数.
A Lot of my packages have 2 Parameters (called P_OdsTbl and P_SrcEtl), and whenever I used Execute package task I bound the Child Parameters to the Parent Parameters.
此后，我发现该项目将以程序包部署模式进行部署，这意味着我需要将参数更改为变量(V_OdsTbl和V_SrcEtl)，并使用变量配置"设置其值.
I've since discovered that the project would be deployed in Package Deployment mode, which means I need to change the Parameters to Variables (V_OdsTbl and V_SrcEtl) and set their values with Variable Configurations.
我在软件包中有很多关于这两个参数的引用，要通过它们全部手动更改它们既费时又不安全(我可能会错过一些引用).
I have many references to these two parameters inside the packages and going through all of them to change them manually is both time consuming and unsafe (I might miss some references).
是否有一种方法可以搜索整个项目中的所有参考文献，或者更好的方法；将其替换为对新变量的引用?
Is there a way to search all the references through the project, or better yet; replace them with references to the new variables?
推荐答案
正如@TabAlleman所述，您可以使用文本编辑器替换.dtsx文件中的文本，因为它们是基于xml的文件.
As @TabAlleman mentioned you can use a text editor and replace text in .dtsx files since they are xml based files.
此外，我建议使用 Notepad ++ ，该功能包含允许用户查找和查找替换目录中的所有文件.
In addition, i will suggest using Notepad++ which contains a feature that allow user to find and replace in all files in a directory.
有关更多信息，请检查以下链接:
For more information check the following link:
- How to find and replace line(s) in multiple files using Notepad++?
- How to Find and Replace Words in Multiple Files
这篇关于SSIS-在整个项目中更改对变量/参数的引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
