SSIS 可以按特定顺序执行任务吗? [英] Can SSIS execute tasks in specific order?

问题描述

嗨

我正在创建一个需要按指定顺序执行以下操作的 ssis 包:

I am in process of creating an ssis package that need to do following in specified order:

1:处理一些数据2:将该数据移动到其他一些表3:获取一些数据并推送到一个纯文本文件中.

1: process some data 2: move that data to some other tables 3: Get some data and push it in a plain text file.

我为这些创建了 3 个存储过程，我为 1 和 2 创建了 2 个执行 SQL 任务"，为第三个创建了一个数据流任务".

I have created 3 store procedure for these, I have 2 "Execute SQL tasks" for 1 and 2 and a "Data Flow task" for 3rd.

现在，当我运行该包时，我可以看到所有 3 个步骤都已完成(没有错误)，但它们的运行顺序不正确.

Now when i run the package i can see all 3 step are completed (no errors) but they are not running in correct order.

我看到先运行第 3 步，然后是第 1 步和第 2 步，我想然后再次运行第 3 步.通常我可以忽略它，但由于文本文件中的数据可能是 700 mb，我需要找到一种方法让 SSIS 依次运行这些任务.

I see step 3 is run first then step 1 and 2, i think then step 3 runs again. Normally i can ignore it but as the data in the text file can be 700 mb, i need to find a way to get SSIS to run these task in sequence.

我尝试过序列容器"但没有成功.

I have tried "Sequence Container" but no luck.

有人可以帮我吗?

KA

推荐答案

您需要使用 优先约束 告诉 SSIS 你的任务需要以什么顺序执行.

You need to use precedence constraints to tell SSIS what order your tasks need to be executed in.

将绿色箭头从任务一拖到任务二，从任务二拖到任务三.

Drag the green arrow from task one to task two, and from task two to task three.

这篇关于SSIS 可以按特定顺序执行任务吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！