Execute task is running without control flow

Shambhu Rai 1,141 Reputation points

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


SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,635 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,323 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,208 questions
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 27,391 Reputation points

    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?



    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.

    0 comments No comments

  2. Olaf Helper 36,091 Reputation points

    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.

  3. Shambhu Rai 1,141 Reputation points

    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

    0 comments No comments