SSIS Log Reports


An effective tool for monitoring the Integration Services logs is a set of Reporting Services reports called the SQL Server Integration Services Log Provider reports. To locate this report pack for download, go to Integration Services Downloads (http://msdn2.microsoft.com/en-us/sql/aa336314.aspx) and search for an article titled "Sample SSIS Log Reports using SQL Reporting Services." These reports pull information from the SSIS execution logs and can help you discover useful metadata about deployed SSIS packages such as execution time and error information. Reviewing these reports routinely might be a valuable tool to spot inefficiencies and opportunities for performance tuning.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net