Hello Everyone, How to use event handlers in SSIS. Can You please suggest me some good links from where i can make gud use of error handling in ssis.

Your starting point should be the MSDN - http://msdn.microsoft.com/en-us/library/ms140223.aspx and then if you have in mind where you want to use them find some specifics, typically, they are used in logging like here: http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspxArthur My Blog

I have used Execute SQL Task tool in control flow where i have typed wrong query . On Event Handlers Executable::Package EventHandler:OnError I have used another Execute SQL task tool On Event Handlers where i have used following Query INSERT INTO dbo.SSIS_events (EIGUID, PackageName, SourceName, EventInfo) VALUES (?,?,?,?) I have created SSIS_events table in database and in above query i m using System variables. I have also done Parameter mapping with system variables. What i want tht when error is encountered in contol flow i want the above query result in my database table. but Its giving me error i cant understand wht is going wrong can u Help me by provinding me some links or some other simple example to understand error handling.

could you please share the error message.. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/