July 25, 2006 at 3:18 am
I have been have some problems geting Execute Package tasks to run successfully in a parent package. I have simplified it to two packages that just insert a row into a table and two execute sql tasks that insert rows into a table
In the parent package I have the workflow success from EP1(Execute Package 1) to EP2 and failure workflow from EP1 to SQlTask1 and another failure workflow from EP2 to SQLTask2. This will run fine.
When I try to add a succes work flow from SQLTask1 to EP2 it never completes. I've tried on completion for the workflow as well. Any insight would be welcome. I've tried to add what the package looks like below.
Cheers,
Execute Package 1 ---> on failure ---> Sql Task 1
|
| on success
|
v
Execute Package 2 ---> on failure ---> Sql Task 1
July 25, 2006 at 10:10 am
If a step is dependent on multiple precedence constraints i.e. workflows, all precedent constraints must be 'true' for the step to execute. In other words, precedent constraints operate as 'AND' rather than 'OR'.
In your package, EP2 would only execute if the 'on success' workflow from EP1 was true AND the 'on success' workflow from SQLTask1 was true. Since that can't happen, EP2 doesn't execute.
I suggest you change the workflow between EP1 and EP2 to 'on completion' and remove the workflow between SQLTask1 and EP2.
Greg
Greg
July 26, 2006 at 6:44 am
You could put the 2 packages in a job as 2 different steps with the 2nd step only executed on success of the first:
Execute Package 1
|
| on success
v
Execute Package 2
5ilverFox
Consulting DBA / Developer
South Africa
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply