How to mark a DTS package as complete even if it errors.

5 pts.
Tags:
DTS packages
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following