Hi Gurus, 

I have scheduled some packages in my production server and they've been running smoothly for couple months. Until last week, I identified that the job kept failing reporting "the package could not be found". When I logged into Integration services and looked under MSDB>Myproject folder, I don't see my packages there anymore. 

Is there anyway I can find out who/how those got deleted those packages. We would like to know how this happened and prevent it in the future. 

Thanks!

What is the version of SQL Server are you using?

If you have CDC or any change data history capture tool (ex:- ignite) you should be able to drill down and find out the root cause.

This us the table where the packge information is stored in msdb

USE [msdb]
GO

SELECT [name]
      ,[id]
      ,[description]
      ,[createdate]
      ,[folderid]
      ,[ownersid]
      ,[packagedata]
      ,[packageformat]
      ,[packagetype]
      ,[vermajor]
      ,[verminor]
      ,[verbuild]
      ,[vercomments]
      ,[verid]
      ,[isencrypted]
      ,[readrolesid]
      ,[writerolesid]
  FROM [dbo].[sysssispackages]
GO

Thanks for your reply. It is SQL server 2008 R2. CDC is not enabled for our databases. 

Seems like the above query only returns all the packages that are currently in the server. There is no tracking information I'm seeing there. 

Is there any other way?

Thanks!