109 Event Handlers in SSIS | How to use Event Handlers in SSIS

[@djadaloui9881]

Thank you for the good explanation !!! keep it up .

[@learnssis]

You are most welcome Sir.

[@mecsihn]

Is it possible to use On Error Event for difirente errors cases? if yes could you please make a tutorial tks

[@learnssis]

I think it will be very hard to do that. When an error occurs the control will move to OnError event handler and there you can get the values from ErrorDescription, ErrorCode etc, so if you want to write specific code for ErrorCode or want to check if specific type of error occurred then you may be try matching a substring inside ErrorDescription and accordingly execute different portion of code but the issue is when an error occurs it triggers the OnError event multiple times for example 3 times for a single error, and the error description will be different for all 3 triggers of the same error, thus it will be really hard to write the use cases for different kind of errors.

[@mecsihn]

@@learnssis yes i'm having a lot of trouble trying to do that. I'm going to try by another way thanks for the Help :).

[@manjunathmanju8320]

How to load the data from Db2 to sql server

[@learnssis]

I have actually never worked on db2. I tried to find on youtube but did not find anything then on google I found this that you can create a linked server from sql server to DB2 and then you can pull data from any db2 to sql server using ssms or ssis docs.microsoft.com/en-US/troubleshoot/developer/host-integration-server/data-integration/creating-linked-server-db2

[@surigadu7319]

wonderful explaination

[@learnssis]

Thank you so much Suri Gadu for your comment,

[@theonlinetribunal9346]

you are just rushing through the examples and not doing a step by step showing and testing the error handling

[@learnssis]

Thanks for your suggestion, I will try to improve it.