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)
 DTS Package Neither Succeeds Nor Fails

Author  Topic 

Crowandazi
Starting Member

9 Posts

Posted - 2005-03-19 : 09:17:34
Greetings all,

I have a package that is not even reaching the stage where it can say to itself "Package Failed" or "Package Succeeded", meaning I don't even get the email that is sent "On Failure".

Any thoughts on what can cause this? I thought anytime a package didn't complete, it was considered a failure and would at least go to the "On Failure" step. Is there a timeout on DTS scripts the way there is on ASP scripts? Even then, shouldn't it return an error?

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2005-03-22 : 08:57:09
Hi
Are you running this from a scheduled job or locally? Check that the package execution is being logged (Package properties - logging tab) and rerun. Then examine the package logs to see which tasks (if any) are being run.
Go to Top of Page
   

- Advertisement -