question

47083641 avatar image
0 Votes"
47083641 asked 47083641 answered

SSIS Package completes successful but doesn't run all executables

I'm running a package in Debug (also tried in SSIS Catalog) and the package is completing successful, but it isn't running all executables.

I've tried checking and changing the Constraints from AND to OR, checked the "OnErrorFailPackage' equals True, run it several times with Breakpoints to validate the variables, and checked the SQL tables for changes (deletes). Everything seems fine.

I think I'm missing something very simple and obvious but would welcome some input.

Here's the package:
101775-ssis-not-continuing.png


sql-server-integration-services
· 1
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.

@47083641,

What do you see in the Execution Results tab?

0 Votes 0 ·

1 Answer

47083641 avatar image
0 Votes"
47083641 answered

I solved my own problem. The Data Flow [Transfer Data (First Query)] never starts because of the dual Constraints. They need to be put into an OR relationship not an AND.

I changed the Constraints to an OR relationship coming out of the [Get Maximum Production Date from destination] executable, which is the wrong place to do it. It needed to be done on the input of the Executable downstream.

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.