sql server dts: Check out EnumPackageInfos in the BOL.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

[quoted text, click to view]
Hi there,

I'm been trying to to find how to list all available DTS packages on SQL
Server, but still got no result. Can anyone please guide me. I'm having hard
time try to understand the Class Library.

Thanks in advanced.

Yanto

Hi there,

I'm been trying to to find how to list all available DTS packages on SQL
Server, but still got no result. Can anyone please guide me. I'm having hard
time try to understand the Class Library.

Thanks in advanced.

Yanto

Hello Yanto,

One way of doing it is this

http://www.sqldts.com/default.aspx?250

another way of course is to query msdb.dbo.sysdtspackages.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]