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

Question

I built an SSIS package via an Import Wizard, and using Management Studio, I can't find the SSIS packages on server. Once I enter the job scheduler, execute a SSIS package does not appear as an option either.

Answer 1

It allows you to choose a server type and server name when you start SSMS. Select "Integration Services" in the dropdown server form, and link to the server. You will then be able to see what things there are in the log. 

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.

Answer 2

hi...

1. Open SQL server Management Studio.
2. Go to Connect to Server and select the Server Type as Integration Services and give the Server Name then click connect.
3. Go to Object Explorer on the left corner.
4. You can see the Stored Package folder in Object Explorer.
5. Expand the Stored Package folder, here you can see the SSIS interfaces.