• Shawn Melton (5/7/2014)


    vanamali (5/7/2014)


    Hi,

    Everywhere somebody talks about logging a different way in SSIS packages. What is the best way to log the trace and errors. I am confused and not sure how much I can rely on SSIS db logging

    Thank you

    Are you aware of what methods are available for logging? They all can log the same type of information is a matter of choosing which destination you want for that information.

    There is no "best method" but the most common method used is the SQL Server log provider. It offers up different ways to analyze your package execution times; there are some canned reports for SSRS that are available from Microsoft that can report on this same information.

    Thank you Shawn for the useful links. I did not know there were reports on the Execution logs. Regards