September 2, 2002 at 10:48 pm
Hello All,
Does anyone know of a way to extract DTS Step descriptions into a table. I am looking for a way to better utilize the DTS logs such as changing or linking the Step name of "DTSStep_DTSExecuteSQLTask_1" to "Deleting Duplicates".
Thanks,
Neal
September 3, 2002 at 3:37 am
The data is stored in an image datatype in sysdtspackages but have not looked at an extracted version to see what it looks like. However, if you right click the item labeled "DTSStep_DTSExecuteSQLTask_1" and goto it's properties you can change to any name you want, this includes transformations.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 5, 2002 at 11:22 pm
quote:
The data is stored in an image datatype in sysdtspackages but have not looked at an extracted version to see what it looks like. However, if you right click the item labeled "DTSStep_DTSExecuteSQLTask_1" and goto it's properties you can change to any name you want, this includes transformations."Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Thanks. Someone else also pointed out the properities in the SQL 2000 disconnected edit mode. This is nice for new packages but causes some problems for pre-existing DTS packages.
I'd love to find a VBScript sample that possibly reference the step Name and Description for a DTS not running in memory.
Regards,
Neal
Edited by - nclarke on 09/05/2002 11:26:08 PM
September 6, 2002 at 10:19 am
Another option is to place the step name below or near each description name in the DTS package. This is what I do. It takes time to put them in, but once they are there they don't change much and then you can relate the logs directly to the steps by looking at the log and refering to the DTS package.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply