Use the following to verify that it exists on the server and make sure that the integration services service is running to view via ssms
SELECT
COUNT(*)
FROM
msdb.dbo.sysdtspackages
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk