Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Martin Babb
Starting Member
11 Posts |
 Posted - 2004-08-02 : 23:59:15
|
HiI have just recently upgraded both the server hardware and SQL Server ( from 7.0 to 2000 )I have been keeping a close eye on the server since the upgrade and have noticed dts packages that are run using DTSRun, appear in Process Info under Current Activity to be using DTS Wizard or DTS Designer as their application.running this SELECT program_nameFROM master.dbo.sysprocessesWHERE spid = '66'returns thisDTS WizardThere is no problem as such I was just wondering if anyone knows why this would be the case as there is no instance of the DTS Wizard open by anyone and there are only two people with access to DTS designer on the server , maybe it is just unfortunate terminology?  ThanksMartin |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-13 : 11:35:30
|
| have you checked the hostname and user running the dts process? can you confirm if there's actual data involved?the command you posted looks more like a lookup of the processes on the Current Activity than running a DTS with data involvement. |
 |
|
|
Martin Babb
Starting Member
11 Posts |
Posted - 2004-08-18 : 00:39:50
|
| HiThe Hostname is RTAUBOX01 ie: itself, The user is itself/username so it is using NT Authentication and when I looked just now the process is running this command. 'truncate table cw116Order' Which is a line from one of my stored procedures called from within a DTS package.And yes the command I posted was just to show that it was in fact the program name that was in use by that process.Still seems a bit odd to me. I never really noticed it under 7.0 |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-21 : 00:46:27
|
| are you still seeing this process? your description tells us that dts is being run on the machine itself,so it means someone must be running the dts package. Have you reviewed the DTS package? it might be running on a schedule or you could ask the person on duty during that time.have you considered if the server is being accessed remotely?just some of the possibilities you may want to explore. |
|
|
|
Martin Babb
Starting Member
11 Posts |
Posted - 2004-08-23 : 19:33:26
|
| Hi JenThe DTS's ( there are many ) are being run from the Local Server, they are being called as steps within jobs run from schedules. As such they are valid processes. I am just not sure why they would be showing as running DTS Wizard or DTS designer to run the actual package.The DTS's do call various Stored Procedures, some of which can run for a couple of minutes, some of the these are still cursor based as I have not been able to come up with a sensible way of converting them to set based as yet. Is it possible that all DTS packages run this way but no one really ever notices it, and if this is the norm, surely there must be a performance hit doing it this way. I probably should mention. All of my DTS packages are files and are called using DTSrun /F "path+filename" /N "package description"Maybe I Should open each DTS package in 2000 and resave. Martin |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-24 : 00:44:43
|
| Hi Martin,From my experience I also see DTS or Designer being run when a package is run by a job. Not sure with the others though. |
|
|
|
|
|
|
Process Info - Application seems odd