Share via

SSIS Error handiling with Propagate system property

Krish 81 Reputation points
2021-03-02T11:48:11.69+00:00

Hi All,

Can some one share your comments on the below issue please ?

I have a SSIS package which is designed to load multiple flat files with for each loop container. each file has individual DFT created. Requirement here is though one of the file from the list if failed with any reason to load, other files should continue the execution and complete the process. But after processing all the files , over all package should fail because one of the file in the list was failed.

I have used Propagate property for each DFT and able to achieve to continue the execution though one of the file if failed, But i am not able to find a way to fail the over all package , my solution is making package Successful which is wrong in my scenario.
Is there any way to fail the package after all the files processed and if any one of the file has the issue ?

Thanks in advance.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-03T03:25:42.26+00:00

    Hi @kirankumar-3620 ,

    We can set ForceExecutionResult as Failure in the properties of package.

    Please refer to the following pictures:
    73480-packageproperties.png
    73613-cf.png
    73633-output.png

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.