SSIS Packages are not listed in integration services

Question

Guys,

We have multiple SSIS packages deployed on a production box. All the scheduled jobs that call these packages run fine.

Whenever I create a new package and try to deploy, I can see the folder structure and deploy fine.

Here is the problem I am facing:

When I log into integration services from SSMS, none of the deployed packages are visible. The tree structure under "Stored Packages" does not expand.

The setup is a 64 bit cluster running SQL 2005 9.0.4226

Any help would be greatly appreciated.

Thanks,

Raj

Answer 1

Just a couple of troubleshooting questions:

1. Is this problem specific to your machine?
2. Can you duplicate the problem from another machine?
3. If you log into the server itself and use its version of SSMS, does it also have the problem?
4. Have you tried reinstalling SQL Server 2008 on the server?
5. Are you able to the see File System and MSDB folders under Stored Packages or does it just never expand Stored Packages at all as you implied in your post?
6. If you run the following queries, do they return any values? The first query should display the list of folders including a Maintenance Plans folder and a blank folder. The second query should show all of your deployed packages if you are relying on server storage.

select *

from msdb.dbo.sysssispackagefolders

select *

from msdb.dbo.sysssispackages