Post reply

Adding Log entry for data flow

  • July 12, 2009 at 10:20 pm

    #134251

    Hi

    I want to add an entry into a custom log table with something of the sort "Inserted 100 records into Table A", each time i insert records into my OLE DB destination. How can i do this ?

    I can get the rowcount using the transformation component, but how do i insert a record into the log table in this data flow, because i can have only 1 destination in a data flow. If i use a multicast, wouldn't it add a lot of unnecessary load?

    Thanks

  • July 12, 2009 at 10:30 pm

    #1023669

    Do it as an Execute SQL task after the data flow - ie, on the Control Flow tab.

  • July 13, 2009 at 12:59 am

    #1023685

    Thanks for the reply.

    I actually found a really good blog at http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx, which explains the solution to my exact requirements.

    Using event handlers at the package level, I dont have to use multile EXECUTE SQL tasks to do the logging. The event handler fires for every Control flow task!

Viewing 3 posts - 1 through 3 (of 3 total)

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