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 2005 Forums
 SSIS and Import/Export (2005)
 How to List All SSIS Package Names

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-08-30 : 10:41:36
hi all,

I have many 2005 SSIS packages that have been imported into MSDB.

Which table or system view can I query to lsit all the package names?

Thanks for your help. John

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-08-30 : 11:04:41
http://blog.hoegaerden.be/2010/01/10/list-all-ssis-packages-deployed-on-your-integration-server/



No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-08-30 : 12:04:05
Thanks, webfred.

Exactly what I had hoped to find!

John
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-08-30 : 14:36:29
welcome


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -