question

kirankumar-3620 avatar image
0 Votes"
kirankumar-3620 asked Monalv-msft edited

SSIS Error handiling with Propagate system property

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

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.



cf.png (24.0 KiB)
output.png (47.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Dear Mona,

Thanks for sharing the details. ForceExecutionResults to failure will make the package fail all the time though we have no issues with any of the files. The use case here is, Fail the package if any of the file has the issues after processing all the other files present in the folder. Make the package success if there is no issues with the files.

Thanks again for your time for the detailed explanation.

0 Votes 0 ·

Hi @kirankumar-3620 ,

We can add error flow redirection in Data Flow Task.

Please refer to the following links:

1.Lesson 4-3: Add error flow redirection

2.An overview of Error Handling in SSIS packages

Best regards,
Mona

0 Votes 0 ·