在SSIS中遍历表时刷新元数据 [英] Meta Data refresh while looping through tables in SSIS

问题描述

情况:我编写了一个查询列表，以便每个查询都从各自的表中选择数据.我想将此查询列表创建为SSIS对象变量，并使用该查询作为DFT中的OLE DB源来遍历每个查询.

The situation: I have a list of queries written so that each select data from their respective table. I want to create this list of queries as an SSIS object variable and iterate through each one, using the query as a OLE DB source in a DFT.

在使用与第一个表不同的表切换到查询后，是否有任何方法可以使DFT源组件不会出现元数据不正确的问题?

Is there any way to do this so that the DFT source component does not have an issue with the meta data being incorrect, after we switch to a query using a different table than the first?

目的地也将发生变化.我知道您可以延迟验证，但我认为这对切换元数据没有帮助.

The destination will also be changing as well. I know that you can delay the validation but i don't believe that helps with the switching meta data.

推荐答案

否，如果所有查询的元数据都不相同，那么您将无法在单个数据流任务中使用它们. DFT的元数据是在设计时设置的，在运行期间无法更改或刷新".您是正确的，延迟验证无济于事.

No, if the meta data is not the same for all queries, then you cannot use them in a single data flow task. The meta data for a DFT is set at design time, and cannot change or "refresh" during a run. You're correct that delaying validation will not help with this.

您可能想研究BiML，它会根据元数据动态创建软件包.

You might want to look into BiML, which dynamically creates packages based on meta data.

这篇关于在SSIS中遍历表时刷新元数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！