List all DTS Packages via T-SQL

[NWChowd]

Hi all,

Is there a way to list all DTS Packages on a Server via T-SQL??

for example, SELECT * <DTS Packages> FROM <sysSomeTable>

thanks,
DMill

======================================
&quot;I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind.&quot;
-David Ricardo, classical economist
======================================

 

[JayKusch]

Are you just after the name of the packages?

Thanks

J. Kusch

 

[HyperRon]

This may help you:

http://support.microsoft.com/defaul...port/kb/articles/Q241/2/49.asp&NoWebContent=1

 

[JayKusch]

exec msdb..sp_enum_dtspackages

Thanks

J. Kusch

 

[ClaireHCM]

also
select * from msdb..sysdtspackages

 

[NWChowd]

Thanks! somehow my eyes missed the table sysdtspackages.

DMill

======================================
&quot;I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind.&quot;
-David Ricardo, classical economist
======================================