12. SSIS and DTS Support

Tired of the scavenger hunt required to track down all the details you need to resolve an issue with your DTS packages and SQL Server 2005 SSIS packages and maintenance plans?

Problems with SSIS and DTS packages can be some of the most difficult to troubleshoot, because there is no easy and unified way to access detailed package log data via the native SQL Server tools. SQL Sentry Event Manager can provide step level details for all your events with just a few clicks of the mouse from any calendar or history list view.

Enabling Package Logging
To enable logging for a DTS package, open the package in DTS Designer then right-click the white space and select Package Properties. On the Logging tab check "Log package execution to SQL Server".

For SSIS packages it's even easier. On watched SQL Server 2005 instances, SQL Agent jobs that have one or more steps with a subsystem type of "SQL Server Integration Services Package" will display an extra option on their context menu, "SSIS Logging Options", which makes it easy to enable/disable SSIS Logging. This includes native maintenance plan jobs on SQL Server 2005, since they utilize SSIS. See the SQL Sentry User Guide for complete details.

Viewing Step Details
SQL Sentry makes it easy to view the results on the SQL Sentry calendar and history list views alongside any other events on a server. Accessing error details for failed package steps has never been simpler! The package step details can be shown by clicking on the grayed area on the bottom right of the event instance.