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 |
|
pravin14u
Posting Yak Master
246 Posts |
 Posted - 2007-02-27 : 01:06:23
|
| Is there a way to quickly document all tables and views a DTS package uses? Is there any system table/view which will hold this information? For one of our projects we need to document these objects so that the client could remove unused objects from the db. There are 20 + DTS packages to go through. Any help/suggestion would be greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-27 : 01:12:14
|
| DTS packages that are stored in SQL Server can be found in msdb.dbo.sysdtspackages. But I don't think that there is an easy way to get what you want.Tara Kizer |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-27 : 01:34:41
|
bidocumenter is possibly an option, but I think it only does SSIS, not DTS.
www.elsasoft.org |
|
|
|
|
|
|
Documenting DTS Packages