Logging - What events are relevant to everyone?

Hot Topic

Problem in creating endpoint
How to give premission to a Active directory group?
Changing Column size/type with Derived Column
Unable to set Default Schema for a group
FREETEXTTABLE
Dumb question: Sanpshot reports
Problem with text field: text input too long, weird characters
Matrix and scopes: Get the value at a given column/row parent scope?
How To !! - Query Master Detail tables and return flat result set
Table won't DROP

SQL Server

SSIS Package runs fine except as a scheduled job
Win 2003 x64 - SSIS error Importing xls and access data
DTS Packages in SQL 2005 - what are they now, etc
Error Message 443
ExecuteSQL task fails and I think it should not
Data Driven Subscription - Will the Report run for each parameter ?
SqlServer 2005 TCP: How to test Key Performance Indicator
2005 Express profiler?
Task converting xls files to csv files ?
Add filters dynamically

Logging - What events are relevant to everyone?

How is everyone using the logging features of SSIS What events are relevant to day-to-day operation Currently we are logging all events except for Diagnostic to a SQL table, and then using event log reporting. What would be the appropriate events used for a production environment




Answer this question

Logging - What events are relevant to everyone?

  • Tekzel

    Andrew,

    There's no right or wrong answer to this but I use:

    • OnPreExecute
    • OnPostExecute
    • OnInformaiton
    • OnError
    • OnWarning

    I haven't seen anything particularly useful in any of the others.

    I also do custom logging using the eventhandlers as so: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx

    -Jamie



  • Logging - What events are relevant to everyone?
Answer this question