How to mark a DTS package as complete even if it errors.
I want to be able to mark a DTS package as though it completed, even if a particular task within it errors off. In other words, if a task errors off just because a file doesn't exist, I will email myself (which I know how to do) but I want the package to exit and mark it as 'complete'. The reason being is....I'm going to have someone review our daily errors. If a package errors just b/c a file doesn't exist, I don't want that person spending time reviewing the error, so I want to mark it as complete. If a package errors because of an error in one of the tasks, then I want someone reviewing that issue.
Can anyone help me?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 18, 2008 8:33 PM
UPDATED:
September 18, 2008 10:18 PM
Answer Wiki:
I don't remember an easy way to tell the package to fail with success instead. You could try a technique like this however.
Before doing to data transformation from the text file to the database stick a SQL task before it. In that SQL task use <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1270919,00.html">xp_file_exists</a> to see is the file exists. If it does not exist use the msdb.dbo.sp_stop_job procedure to stop the job which will then cause the DTS package to simply stop. If the file does exist do nothing and continue the package processing.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
