Solved

dts step names.. :-(

Posted on 2004-08-08
3
584 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Slow Connectivity over ODBC 8 34
TSQL - How to declare table name 26 30
Query Syntax 17 34
SQL view 2 27
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

770 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