Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime. This will allow you to log the output to 5 providers...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
04-09-2008
Filed under: sql server, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer