question

NewUserBI avatar image
NewUserBI asked

SSIS Package Not Finishing Execution

I am trying to execute an SSIS package and after it starts the execution, it is having an error in data flow source.

There is a lookup in the same data flow task, and although there is an error in the execution, the lookup transformation is keep on executing, and the package is stuck.
The package execution is not stopping and it keeps on executing indefinitely, even though there is an error.

The data flow task looks like the below:

1634566945853.png




I have also tried enabling 'FailPackageOnFailure' and 'FailParentOnFailure', but the package execution still does not stop after the 'flat file source' has an error.

Please let me know if there is anyway to stop the execution after the error.

Thanks in Advance.

ssis error
1634566945853.png (26.2 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

4 Answers

·
anthony.green avatar image
anthony.green answered

Your precedents are wrong you have it set to completion not success. So even a failure will still say to carry on.

Green for success

Red for failure

Blue for complete regardless of success or fail.

If you want the import to fail on issue at the flat file set the constraint to be a success so it never enters the derived column task.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

NewUserBI avatar image
NewUserBI answered

Thanks Anthony for the answer.

The precedence constraint can be set in the control flow, but this is inside the data flow.

I don't find any option for specifying precedence constraints inside the data flow task.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image
anthony.green answered

Yeah sorry about that I obviously needed more coffee yesterday.

So what is the error on the flat file source?

Can you post the output messages?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

NewUserBI avatar image
NewUserBI answered

Following is the error I get:


1634752395126.png


1634752395126.png (27.2 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.