Retrieving DTS Packages name 1

[davideart]

Hy all.

I have created a lot of SQL DTS packages (saved on server msdb) and I would like to know how I can retrieve their names using a VB application.
That means:
1) are the DTS names saved in some DB table?
or
2) can I retrieve them from a stored procedure?
or
3) some other way?

Any help will be greatly appreciated.
Thank you in advance, David

 

[AshleyRickards]

Using this sql statement after your Vb code connection string.

"use msdb
select distinct name from sysdtspackages"

HTH Ashley L Rickards
SQL DBA

 

[davideart]

Thank you ASH001, this is just what I needed to know.
I voted your post helpful.

Bye