Error Handling in SSIS Packages [SSIS Event Handlers | SSIS Data Flow Task]

[@max6760]

Thanks for the excellent tutorial! Besides learning the error handling, I have also learnt how to use SqlStatementSource which I never knew before. SqlStatementSource allows me to build the sql script conveniently, so that I don’t have to use the tedious parameter mapping.

[@bharathy516]

Excellent ! I was searching for ways to do error handling under situations of ‘column delimiter issues’ .This video helped to log those errors and helped to continue the iteration even when the package fails ..

[@cknight44]

Great tutorial. Thank you so much.

[@kemelewf1531]

Well done.

[@yagersew437]

thank you bro for sharing a wonderful content...hope you will continue doing this addressing various topics on DB

[@nimikajadav3004]

VEry Nice. Easy to understand.

[@Mahmood-n7s]

Well explained, thank you Aqil sir

[@gregorytaylor2749]

Great tutorial 👍👏 Thanks!!

[@sesedmien1]

Great content, keep them coming! Thank you.

[@MdSamiulIslam-e1i]

great effort

[@thyagaraj1124]

Excellent explanation

[@gurunathad13]

Thank you 🙏

[@thyagaraj1124]

Sir ,We are expecting more real time scenarios.

[@gurunathad13]

@@thyagaraj1124 sure

[@shekargunukuntla4031]

Good explaining brother

[@gurunathad13]

Thanks brother... Happy Learning!!!

[@nitagawade3330]

Awsome!!!

[@koushikdey100]

Superb

[@mariahalt4603]

This is a great video. But I have one wish! Is there a way to capture the name of the component that triggered the error handler? What I see in this example is the name of the Task that is inserting the record. I'm more interested in capturing the culprit's name.

[@mohanrajcreations3220]

Sir I am using flat file source and data conversion and script component I want to capture the row which has error and column name I am inserting the data into script component

[@pravinshahapure2936]

Hi Sir, Thanks for the information, I have a question, this information is will show the how-to log errors? but I want to know how to debug and fix that errors? ...If execute task having procedures and functions then how we log the errors?

[@gurunathad13]

We can enable breakpoint to check exact value passing to query and to do debugging and if we have direct SP then we need to test it via SQL server only...In some cases we can also enable logging too

[@YuTingCheng-mk3ye]

Hi Gurunatha, I have faced an issue regarding NT AUTHORITY LOG ON, is there a way to resolve this?

[@bibeklal]

How to continue the package processing instead of failing it while using EventHandler? We can see while using component level error handing , errors are logged but processing completed, how to achieve same with EventHandler

[@gurunathad13]

This video covers both component level and event handlers level ... Kindly check ...thanks

[@PS-vc6ef]

@@gurunathad13 Thank you so much for the video!!! Yet, like Bibek had asked, how can we continue package processing using EventHandler? I am assuming this can be done by going to SSIS up in the text editor and initiate error logging?? How about an email notification? Can you make a video on that????

[@gurunathad13]

@@PS-vc6ef for email notifications kindly use script task where you need to write the custom c# or vb code to send mail with error log text...best way to log event handler is SQL table logging

[@PS-vc6ef]

@@gurunathad13 Thank you so much sir! What if I wanted to catch Null values and incorrect data such as 6 digits social security numbers in a table in sql server while the package is executing? Is there a way to do that?

[@gurunathad13]

@@PS-vc6ef use conditional split component to redirect according to needs

[@mariyajames6603]

Hello sir, I like your video this very nice but I am facing problems for system, I m unable to downloading ssis tool applications

[@bishwajitpaul2488]

Hello Sir, When I run my package, I can capture error on flat file but when I try to log the error using OnError event handler, It doesn't kick off and log anything while I ran the package(though I have setup event handler in Dataflow task level). Can you please advise

[@gurunathad13]

Hi, kindly check whether you have created event on package level or any other component level ....Try to use logging method and check

[@elurisahadevreddy-ck4sn]

I am unable to see tool bar in visual Studio when I open a existing package

[@PraveenKumar-bx4to]

Hi, how to move file to error folder if i got error at ole db destination and also i need to continue next file. I don't want log anything in db. If there is any error in data flow task need to move file error folder and continue next file

[@gurunathad13]

Try to use file system task and ignore errors in data flow in case if you don't want to log any errors ...but to move folder or file use file system task component

[@PraveenKumar-bx4to]

@@gurunathad13 done that if i ignore error on error not catching anything. So file system task not moving file. If i consider fail componet , some how file system coping file to destination but not moving. If i select operation move file getting exception

[@gurunathad13]

@@PraveenKumar-bx4to if you don't want to log anything then in the error handling use File type logging options which will log error in text file and you can move that text file to some where else and this way you don't need to save any error log in db ....thanks

[@ankitsaxena565]

Sir can you share LinkedIn id or Gmail id i have some problems related to ssis

[@gurunathad13]

Kindly mail me on [e-mail]