Read information about local packages

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

SQL Server Development (2000)

Read information about local packages

Author

Topic

Hippi
Yak Posting Veteran

63 Posts

Posted - 2005-02-28 : 16:00:11

Hi,

I have to write a program to read the names of local pacakages under DTS.
Do u guys know from which table can I get that information?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-28 : 16:01:30

msdb.dbo.sysdtspackages

Tara

Hippi
Yak Posting Veteran

63 Posts

Posted - 2005-02-28 : 18:08:36

quote:
Originally posted by tduggan

msdb.dbo.sysdtspackages

Tara

Thanks so much, Tara.
One more question:
Where can I get the list of databases in Analysis Services?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-28 : 18:11:59

I've never used Analysis Services before, so I'll leave it up to someone else to answer that for you.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources