s**********o 发帖数: 14359 | 1 我一个SERVER上有很多SSIS PACKAGE STORED IN MSDB,
如何找出CONNECTION MANAGER用IP ADDRESS的呢
我的一个FILE SERVER要MIGRATION,用IP的话就不WORK,
假设有300个PACKAGES要SEARCH | l*****e 发帖数: 3343 | | s**********o 发帖数: 14359 | 3 powershell貌似无所不能,但不会用,公司还不让装 | d**********3 发帖数: 1186 | 4 How did u deploy the package?
If you deployed to SSIS instead of file mode, you should find this info in
SSIS(through SSMS).
But still questions for you,you did not expose connection managers in XML/DB?
if not, how u make it work after moving ur packages in DEV to Prod? | s**********o 发帖数: 14359 | 5 因为PACKAGE有好多年历史,不同的DEPLOY的方法都有,还有老的DTS转过来的,
现在的问题是我也不知道他们都是怎么DEPLOY的,所以问有没有UNIVERSAL的
方法SEARCH一下。
DB?
【在 d**********3 的大作中提到】 : How did u deploy the package? : If you deployed to SSIS instead of file mode, you should find this info in : SSIS(through SSMS). : But still questions for you,you did not expose connection managers in XML/DB? : if not, how u make it work after moving ur packages in DEV to Prod?
|
|