Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

dts step names.. :-(

Hi experts.
does anyone knows how to change the dts step names. when I see the dts log history, It shows "DTSStep_DTSDynamicPropertiesTask_1", "DTSStep_DTSExecuteSQLTask_3" ... etc. I think This can be change as follows.
1. Save the dts as .bas file
2. Change the step names.

Is it any luck to change this names through EM?

Thanks
DishanF
0
Dishan Fernando
Asked:
Dishan Fernando
1 Solution
 
charlesejonesCommented:
You can do this through Enterprise Manager.  It may vary slightly depending upon what type of step you are doing.  You should be able to open your DTS package, then double click on the step in question and change the description.  It should then be included in the GUI when you run the step and in the logs as well.  Good luck!
0
 
Dishan FernandoSoftware Engineer / DBAAuthor Commented:
Hi.
No. didnt work!. It didnt effect to the seeing the package logs.
0
 
SNilssonCommented:
Open your DTS package and in the package menu select 'Disconnected Edit'.

From there you can change both 'Task Name' and 'Name' (expand the 'steps' item).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now