Package execution logs
Although it has been available since SQL Server 2005, SSIS logging has been fairly basic. Most developers have coded some sort of custom logging to make up for the inadequacies in SSIS. However, in SQL Server 2012, SSIS can automatically provide more detailed runtime logging to a table, tex file, the Windows event log, XML file, or even a SQL Server Profiler trace.
Logging can be enabled for all SSIS tasks at the package level, or it can be enabled just for individual tasks at the component level, without enabling it at the parent package level. In addition, logging can be written to multiple logs from the same package or task, which gives great flexibility.
Furthermore, even the events that are logged and the information ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
