sql server dts: This is a pretty trivial problem, but I don't want the log file to be confusing when an operator reads it

I created one DTS package to import one file, then opened/saved as a different package in order to clone the package. I changed all of the properties in each package. But when they run, they both have the same "Step Name" in the exception (log) file. I can't find where to change this name. Anybody seen this

Example below: (note the different package names, but same step names

******************************************************
DATA TRANSFORMATION SERVICES: Data Pump Exception Lo
Package Name: OMNI_LoadData_PLUS_A
Step Name: Copy Data from PEPEOBJ to [abbsdev].[dbo].[PEPEOBJ] Ste
******************************************************
DATA TRANSFORMATION SERVICES: Data Pump Exception Lo
Package Name: OMNI_LoadData_PLUS_S

Have you tried the 'disconnected edit' feature in DTS Designer? I haven't
used it for this specific purpose, but can guess, it is going to be a messy
job.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
This is a pretty trivial problem, but I don't want the log file to be
confusing when an operator reads it.

I created one DTS package to import one file, then opened/saved as a
different package in order to clone the package. I changed all of the
properties in each package. But when they run, they both have the same
"Step Name" in the exception (log) file. I can't find where to change this
name. Anybody seen this?

Example below: (note the different package names, but same step names)

*******************************************************
DATA TRANSFORMATION SERVICES: Data Pump Exception Log
Package Name: OMNI_LoadData_PLUS_AM
Step Name: Copy Data from PEPEOBJ to [abbsdev].[dbo].[PEPEOBJ] Step
*******************************************************
DATA TRANSFORMATION SERVICES: Data Pump Exception Log
Package Name: OMNI_LoadData_PLUS_SP
Step Name: Copy Data from PEPEOBJ to [abbsdev].[dbo].[PEPEOBJ] Step

The step name is correct. The problem is that the step not is not what you
"see". The label used in the GUI is actually the Task (not even step)
description property. You can change the task and step names through
disconnected edit as Vyas suggest, but be careful.

The task name is also stored in the step, see the TaskName property.

The step name is stored on precedence constraints. The constraint is held by
the destination step, and has a StepName property that stores the preceding
step name.


--
Darren Green
http://www.sqldts.com


[quoted text, click to view]
different package in order to clone the package. I changed all of the
properties in each package. But when they run, they both have the same
"Step Name" in the exception (log) file. I can't find where to change this
name. Anybody seen this?
[quoted text, click to view]