是否可以找到 SSIS 包中使用的所有表的列表? [英] Is it possible to find list of all the tables used in a SSIS package?

问题描述

我需要找到 SSIS 包中使用的所有表的列表.我知道的一种方法是在 textpad 中打开包并搜索表格.但是，是否有任何可靠且快速的方法可以使用 C# 或其他一些技术来做到这一点?

I need to find the list of all the tables used in a SSIS package. One way that I know of is to open the package in a textpad and search for the tables. But is there any reliable and fast way to do this using C# or some other technology?

推荐答案

我不确定是否有可靠的方法来做到这一点.例如，表可以被变量引用，这些变量可以在运行时更改值或通过包配置或数据库中的值进行修改.因此，虽然您可以查看 XML 代码以查找表的提及，但您不能保证对于任何给定的包都是 100% 正确的.您可能会在包执行时运行类似 Profiler 的程序，然后查看输出以查看访问和/或修改了哪些表 - 然而，这将是一项非常手动的任务.

I'm not sure there is a reliable way to do this. For example, tables can be referenced by variables that can change value at runtime or be amended via package configurations or values in a database. So while you could look through the XML code for mentions of tables, you could not guarantee with would be 100% correct for any given package. You could possibly look at running something like Profiler while the package is executing and then go through the output to see what tables were accessed and/or amended - this would be a very manual task however.

这篇关于是否可以找到 SSIS 包中使用的所有表的列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！