Hello,
Here is the scenario:
I am running two script logics from an SSIS package in the application called Reporting. Now I need to add a third task that runs script logic from another application called CostAnalysis. I have already tried using logic task, it wont work. now I am trying to do it through execute package task. In the execute package task, I added a File connection that points to the exact location where the 2nd dtsx file(in other application called costanalysis) is located, and referenced that connection in Execute package task.
Here is Issue:
Before I added this 3rd task, the package named pushtocostanalysis was running just fine. After adding the 3rd step(execute package task), the package just stops running after 2 seconds and doesnt even create a log file! How could this be?
Thanks.