Hi,

Today I am facing problem when invoking multiple packages from a master package.

Here is the scenario.

Master Package has the below tasks conigured.

- For Each loop container (To loop through a folder for executing all the packages available in that folder)

-Execute Package Task (All the packages are placed in the file system)

Child Package :1

-consist of 3 Execute SQL task (Which is just a insert statement) -This package runs successfully.

Child Package:2

-consist of 2 Execute SQL task (Which is just a insert statement)

First SQL task runs good.

Second SQL task has syntax problem.

I have configured Checkpoint in all these Child packages.In my case -Child PAckage:1 runs successfully.But Child Package :2 fails at the second Execute SQL task.So my checkpoint works good when i do the needed modification.

But the issue is My For EachLoop container executes Child PAckage:1(Which should not happen) and then the Second Execute SQL Task (Which failed in first run).Because of the checkpoint file SSIS is not running the first Execute SQL task in the Chuld Package:2.

Please suggest how to keep track of failed package alone and to restart from that point.

Thanks

Nisha.V