Skip to Content
0
Former Member
Dec 07, 2011 at 06:57 AM

Execute Process Task Issue

31 Views

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.