How do I view the SSIS packages in SQL Server Management Studio?

Caveatrob picture Caveatrob · May 20, 2009 · Viewed 242.9k times · Source

Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go into job scheduler, either.

Answer

Casey Williams picture Casey Williams · May 20, 2009

When you start SSMS, it allows you to choose a Server Type and Server Name. In the server type dropdown, choose "Integration Services" and connect to the server.

Then you'll be able to see what packages are in the db.