SSIS 在控制流任务之间传递数据源 [英] SSIS Pass Datasource Between Control Flow Tasks

问题描述

我在解决这个小问题时遇到了麻烦，希望有人能帮助我.

I'm having troubles solving this little problem, hopefully someone can help me.

在我的 SSIS 包中，我有一个数据流任务.这里发生了几种不同的转换、合并和转换.

In my SSIS package I have a data flow task. There's several different transforms, merges and conversions that happen in here.

在数据流任务的最后，有两个数据集，一个包含两个需要比较的数字，另一个包含一堆记录.

At the end of the dataflow task, there is two datasets, one that contains two numbers that need to be compared, and another dataset that contains a bunch of records.

理想情况下，我希望将这些传递给一个全新的数据流任务(单独的序列容器)，在那里我可以对其进行一些验证工作并分离逻辑.

Ideally, I would like to have these passed onto a whole new data flow task (separate sequence container) where I can do some validation work on it and separate the logic.

我终其一生都无法弄清楚该怎么做.我尝试研究脚本并将数据集存储为变量，但我不确定这是正确的方法.

I cant for the life of me figure out how to do it. Iv tried looking into scripting and storing the datasets as variables, but I'm not sure this is the right way to do it.

下一步是将大型数据集导出为电子表格，但在此之前，我需要比较另一个数据集中的两个数字并确保它们是正确的.

The next step is to export the large dataset as a spreadsheet, but before this happens i need to compare the two numbers from the other dataset and ensure they're correct.

推荐答案

要将一个数据流中的数据传递到另一个数据流，您必须有一个临时位置.

To pass data flowing in one dataflow to another, You have to have a temporary location.

这意味着您必须将数据放入一个数据流中的目的地，然后在另一个数据流中读取该数据.

This means that You have to put data in destination in one dataflow and then read that data in another dataflow.

您可以将数据放入多个目的地:

You can put data in number of destinations:

• 数据库表
• 原始文件
• 平面文件
• 数据集变量(记录集目的地)
• 您可以使用相应的源组件或通过编写脚本或其他方式读取的任何其他目标组件

原始文件旨在用于此类情况.它们是二进制的，因此它们的写入和读取速度非常快.

Raw files are meant to be used for cases like this. They are binary and as such they are extremely fast to write to and read from.

如果您坚持使用记录集目标，请查看 http://consultingblogs.emc.com/jamiethomson/archive/2006/01/04/SSIS_3A00_-Recordsets-instead-of-raw-files.aspx 因为有没有记录集源组件.

In case You insist to use recordset destination take a look at http://consultingblogs.emc.com/jamiethomson/archive/2006/01/04/SSIS_3A00_-Recordsets-instead-of-raw-files.aspx because there is no recordset source component.

这篇关于SSIS 在控制流任务之间传递数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！