Post reply

When A Referenced Package Fails

  • May 14, 2007 at 9:07 am

    #76704

    Hello,

    If a SQL Server 2000 DTS package contains an Execute Package Task, and the package defined in that task fails, will that cause the parent package to fail? The parent package I am deailing with is run by a Job. If the child package fails, and If the Job of the parent package is set up to notify via email in the event of failure, will the Job for the parent package send an email notification of failure if the child package fails?

    Thanks for your help!

    CSDunn

  • May 14, 2007 at 10:05 am

    #706277

    No, it will not.

  • May 14, 2007 at 12:47 pm

    #706314

    Thanks. After some testing, I set the child packages to 'fail on first error'.

    CSDunn

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply