SSIS Package stays in execution and doesn't finish execution nor gives an error

Question

I have created a package which has multiple data flow tasks. It also includes BEGIN TRANSACTION as an Execute SQL Task

When package is called by another package, it doesn't finish execution. However, if it is run by hand, it executes successfully.

Here is the screenshot of the package

Answer 1

You need to put a local task after calling a child package. In other words, the call package task shouldn't be the last task in the main package.