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.
| Author |
Topic |
|
govindts
Starting Member
33 Posts |
 Posted - 2008-02-22 : 13:58:10
|
| All, I am new to SSIS package. I need to know how to handle the errors in SSIS work flow. Can you please provide any specific procedure or method to handle the error. Basically, i wanted to trap the failed records and alert through email... I would be pleased if any one could answer for this.. |
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-22 : 14:37:49
|
| You can do this several ways, but I need a little more info. What step in the dataflow are they erroring out on? Do you want an email for every record, or one email with the records? Do you want the records as an attachment to the email or in the text of the email? |
 |
|
|
govindts
Starting Member
33 Posts |
Posted - 2008-02-22 : 17:22:31
|
Hi, Your email is greatly appreicated and thank you again. I am currently working on ETL development on SSIS. What i need here is, the ETL will be running and refresh the data mart. At the end of the data mart, i need to send an email to every one with failed records info. I think, the best way is to send the email attachment with failed records. Please let me know the approach. ThanksGovindquote:
Originally posted by Qualis
You can do this several ways, but I need a little more info. What step in the dataflow are they erroring out on? Do you want an email for every record, or one email with the records? Do you want the records as an attachment to the email or in the text of the email?
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-23 : 03:30:16
|
quote:
Originally posted by govindts
Hi, Your email is greatly appreicated and thank you again. I am currently working on ETL development on SSIS. What i need here is, the ETL will be running and refresh the data mart. At the end of the data mart, i need to send an email to every one with failed records info. I think, the best way is to send the email attachment with failed records. Please let me know the approach. ThanksGovindquote:
Originally posted by Qualis
You can do this several ways, but I need a little more info. What step in the dataflow are they erroring out on? Do you want an email for every record, or one email with the records? Do you want the records as an attachment to the email or in the text of the email?
You can do this by using a sendmail task. Also you need to use redirect row option in your configure error output property and write error rows to a file. This file can be used in send mail task to inform users about error records. |
|
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2008-02-23 : 22:32:39
|
| If I read correctly, you are looking for a mechanism to track any error that occurs in SSIS and send a notification. However, there's not a silver bullet solution for this. What constitutes an error? If a record fails validation, is that an error or is it expected behavior? Your business case(s) will dictate the answers to what events are defined as errors.Your best bet will be to use a combination of tactics, including redirecting error rows to a file, performing additional processing on failed records, etc. You could use a variable with package scope as an accumulator to track the number of errors, if any, have been detected and send an e-mail with that information.Hope this helps...Tim---------------------Tim Mitchellwww.BucketOfBits.com |
|
|
|
|
|
|
|
|
Error handling in SSIS