Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

dts step names.. :-(

Posted on 2004-08-08
3
588 Views
Last Modified: 2013-11-30
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
Comment
Question by:Dishan Fernando
3 Comments
 
LVL 1

Expert Comment

by:charlesejones
ID: 11750268
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
 
LVL 8

Author Comment

by:Dishan Fernando
ID: 11750652
Hi.
No. didnt work!. It didnt effect to the seeing the package logs.
0
 
LVL 8

Accepted Solution

by:
SNilsson earned 250 total points
ID: 11750999
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question