Post reply

Event Handlers Not working

  • January 13, 2011 at 2:29 am

    #144285

    I have a simple data flow task in my package and want to implement a OnError even handler on the DFT. In event handler I have only one execute sql task to insert a record in temp table.

    My event handler never never never neever get executed... I tried all options from MSDN forums...

    Now I am only concerned about any installation problems...

    I am using Visual Studio 2008 , .Net Framework3.5 SP1

    SQL server 2008

    Please help... 🙁

  • January 13, 2011 at 3:58 am

    #1272926

    Are there errors in the data flow so that the event handler should be executed?

    Are there any errors related to the event handler?

    Is the DisableEventHandlers property of the DFT set to False?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 13, 2011 at 5:14 am

    #1272953

    There are no errors in the data flow.

    DisableEventHandlers property of DFT is set to false.

    How do i find errors related to event handler? Rather I think, this is where I need help from.

  • January 13, 2011 at 5:23 am

    #1272956

    me_always (1/13/2011)

    There are no errors in the data flow.

    DisableEventHandlers property of DFT is set to false.

    How do i find errors related to event handler? Rather I think, this is where I need help from.

    So you create an event handler for the data flow that will fire OnError.

    The data flow doesn't have any errors.

    And you are surprised the event handler doesn't fire?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 16, 2011 at 10:33 pm

    #1274084

    I mean there arent any validation errors in my package.

  • January 16, 2011 at 11:44 pm

    #1274094

    Got the answer..

    I was executing my data flow task by right clicking..

    When I run the entire package, event handler works..

    Thanks everyone for help.

  • January 16, 2011 at 11:54 pm

    #1274095

    me_always (1/16/2011)

    Got the answer..

    I was executing my data flow task by right clicking..

    When I run the entire package, event handler works..

    Thanks everyone for help.

    Glad that you found the solution!

    But for the future, those things, such as executing task only by right clicking, are worth mentioning in the original question.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 17, 2011 at 12:10 am

    #1274101

    Sure thing..

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply