Sentry US ACSK-EM Bedienungsanleitung PDF herunterladen (Seite 27)

18. 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. 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 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.

1 2 ... 22 23 24 25 26 27 28 29 30 31

Keine Kommentare

Sentry US ACSK-EM Bedienungsanleitung Seite 27