Have you expanded the view to show error details?

-----Original Message-----
From: Gord Debiasi
[mailto:mssqldba-ezmlmshield-x32407369.[Email address protected]
Sent: Monday, May 28, 2007 9:54 AM
To: LazyDBA Discussion
Subject: DTS Logging

Hello All,

Is there a method to have more descriptive logging from my DTS packages?
Currently, it just reads
Step 'DTSStep_DTSExecuteSQLTask_3' succeeded
Step Execution Started: 26/04/2007 7:37:32 AM
Step Execution Completed: 26/04/2007 7:37:34 AM
Total Step Execution Time: 2.219 seconds
Progress count in Step: 0

However, I do not know what exact step this is because I have parallel
steps in a large DTS package. The actual step name in the logging would
be great.
Any help would be appreciated. By the way, I am running SQL 2000.

Thanks




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page