Elam, Debbie
DElam at jenkens.com
Tue Oct 19 07:38:11 CDT 2004
Provided the server has the add ins for sending mail, you could write a send mail on failure for that step inside the DTS. Usually for testing I run the DTS manually and it will let me know if any steps failed and which ones they are. As long as they are labeled, I have been able to troubleshoot fairly easily. Debbie -----Original Message----- From: Ken Stoker [mailto:kens.programming at verizon.net] Sent: Monday, October 18, 2004 5:15 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Check for an error in a script Does anyone know how to test to see if an insert fails in a DTS package? I am trying to create a script that will be part of a DTS package that runs nightly, importing data from a text file into a holding area, and then the script will move the data from the holding area into the production tables. What I am trying to do is if the record won't insert because of some violation, a failure flag is flipped for that record to signify a need to be reviewed by someone. If the insert is successful, then the record is removed from the holding table. Any help is appreciated Thanks Ken _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.