How to know DTS packages in 2000 sserver

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

How to know DTS packages in 2000 sserver

Author

Topic

kallushashi
Starting Member

11 Posts

Posted - 2011-09-22 : 11:36:40

Hi,
i am new to this DTS packages where iam having one problem in my 2000 server the DTS packages got scheduled via windows i want to know what DTS packages are running on the server could any one please help me regarding this issue it's urgent

shashi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-22 : 13:18:54

you need open up jobs in sql agent and check the steps to understand which package its calling.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-22 : 13:35:44

This will show which ones are called via SQL Agent jobs (but not from Windows task scheduler):

select	j.name, s.command
from	sysjobs j
join	sysjobsteps s
on	j.job_id = s.job_id
where	j.enabled = 1
and	s.command like 'dtsrun%'

kallushashi
Starting Member

11 Posts

Posted - 2011-09-22 : 23:55:05

Russel thanks for the reply but on my server it is scheduled through windows how to know the DTS packages if it is scheduled through windows please give me the solution

shashi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-23 : 01:12:10

where are packages stored? are they stored in sql server or in file system?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

kallushashi
Starting Member

11 Posts

Posted - 2011-09-23 : 07:18:39

it got stored in system file not in server so please give me the solution for this issue i want to know what DTS packages are running on the server.

shashi

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-23 : 07:24:26

Review the scheduled tasks.

If you need to know what it running at a particular time, execute sp_who2, looking for program name DTS Designer.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources