Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Reg: DTS Scheduling

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-02 : 08:51:52
shashidhar writes "Hi All ,
I have two Packages A and B . I combines two packages in to one Package C(By using Execute Package Task) using A and B . I scheduled Package C . But Package C shows successful status when even failed Package B .
When Package C runs manually .It is failing . I do not know why scheduler is not showing Failure Status .
How to show scheduler status as Failed the job C whenever either Job A or Job B fails .
Please help this . I really appreciate .

Thanks & regards ,

Shashidhar N ."

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-03-02 : 12:19:14
Is package C set to fail on any task failure?

Mark
Go to Top of Page

shashidharsemail
Starting Member

1 Post

Posted - 2007-03-06 : 00:32:38
Yes
Go to Top of Page
   

- Advertisement -