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.
| Author |
Topic |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-01-30 : 13:47:33
|
| Hello -I am trying to find out if there is a system table or dynamic management view that might help me to list out all of the ssis packages that are stored on the server (in the ssis package store).Does anyone know of such a view/table?I have searched around, but so far I haven't been able to locate anything.Thanks - will |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-01-30 : 14:01:33
|
| Hi -I just figured it out. I was looking in the wrong db. I forgot that the SSIS package info is stored in MSDB.I found the necessary tables in the MSDB database to derive my list. - will |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 14:02:55
|
If it is stored in MSDB Database ,then you can with:Select * from msdb.dbo.sysdtspackages90 But it won't work if you have saved SSIS in Filesystem. |
|
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-01-30 : 14:12:36
|
| Yup, I know. We have all of our SSIS packages store (in MSDB). |
|
|
|
|
|
|
List all SSIS packages on server?