Does anyone know where SQL server 2000 stores the step name when you create a task in a DTS package? Example, I created an 'Execute SQL Task' and gave it a name as 'Create Stored Procedures'. Yet if you look at the DTS log or in 'sysdtspackagelog' or 'sysdtssteplog' it stores the internal name 'DTSStep_DTSExecuteSQLTask_5'. I have several 'Execute SQL Tasks' in this DTS package and they are being changed often. I would like to use the msdb..sysdtssteplog information but I need to have my description, not the internal description.....
Where is that value being stored? I think it may be being stored in msdb..sysdtspackages as the packagedata field. This field is an 'Image' datatype and I can not read the values.
I am attempting to use this table rather than creating a unique logging method (to my app) seems mad to create a logging method and to not allow the steps to be named cept for the 'DTSStep_DTSExecuteSQLTask_(1, 2...n)'
Again, thanks for your help.