Solved

SQL Server 2000 -  is it possibale to get a list of DTS packages?

Posted on 2008-10-22
4
326 Views
Last Modified: 2013-11-30
I have SQL Server 2000 on my computer (the name of the instance is SVR2000).  I have 3 DTS packages- MyPack1,  MyPack2, MyPack3.

1) Is it possible to create a code (C# for example) that returns the names of DTS packages - in this case it will be MyPack1,  MyPack2, MyPack3 ? Thanks


0
Comment
Question by:niceguy971
4 Comments
 
LVL 2

Assisted Solution

by:-JerodR
-JerodR earned 160 total points
Comment Utility
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 160 total points
Comment Utility
Sure.  All versions of your DTS Packages are stored in the table sysdtspackages in MSDB.  If you just want the unique names than you can use a DISTINCT clause.
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 180 total points
Comment Utility
@acperkins: Well, the ones that are saved to the database are, but what about external packages?
can also select * from msdb..sysjobs to see what other things are scheduled. and exec master..xp_cmdshell 'dir/s *.dts'
0
 

Author Closing Comment

by:niceguy971
Comment Utility
Thanks!!!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 shrink a transaction log file down to a reasonable size.

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now