Solved

dts step names.. :-(

Posted on 2004-08-08
3
578 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:dishanf
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:dishanf
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now