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 2008 Forums
 SSIS and Import/Export (2008)
 Where is the SSIS MSDB package stored?

Author  Topic 

thebrenda
Starting Member

22 Posts

Posted - 2013-08-02 : 09:58:57
I deployed some SSIS packages to SQL Server MSDB. I see them in the SSIS but started wondering where is the package really stored. Looked at the System Databases -> MSDB -> dbo,sysdtspackages but there was nothing in it. Do i not have permissions or are the packages stored somewhere else?

thebrenda
Starting Member

22 Posts

Posted - 2013-08-02 : 10:42:51
Found it
sysssispackages under MSDB database

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-03 : 00:16:12
sysdtspackages will have details of legacy DTS packages if stored in MSDB

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

dgh898
Starting Member

10 Posts

Posted - 2013-08-08 : 23:09:53
unspammed
Go to Top of Page
   

- Advertisement -