It's messy and it's tricky, but here goes...

In the package editor, click on a blank section then click on Package on
the toolbar. Click Disconnected Edit and there you have it. If you
change the task name, you also have to change the task name under the
associated step name. For example, under tasks I have
DTSTask_DTSExecuteSQLTask_1 and under steps I have
DTSStep_DTSExecuteSQLTask_1. If I were to change
DTSTask_DTSExecuteSQLTask_1 to DeleteAllFiles, I would need to change
the taskname under DTSStep_DTSExecuteSQLTask_1 to DeleteAllFiles.

Good luck!



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