Execute task is running without control flow

Question

Hi Expert,

when I am executing package it is not running container but when I am running container then only everything is running in SSIS

Answer 1

yes but when i run execute package it runs all control flow and execute task and it is running successfully butt when i only run execute task then it oonly run that dataflow

i am using sequence container and in that using for each loop .in sequence container ... i am truncating the data and then for each loop for archiving the file after load

Answer 2

That's not a simple sequence container, it's ForEach loop container and if the ForEach expression don't return a result, then the contained flows aren't executed; that's the way a loop works.

Answer 3

Hi @Shambhu Rai ,

Could you please share the whole control flow so that we may know the whole design of the package?

Do you mean when you run the package, the container do not run but when you only run the container, all the component will run successfully?

If yes, the error is a bit strange that I do not meet with it before.

Could you please re-start VS and re-open the project and run again to see if it will work or not?

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.