Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)
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.

2 Answers

0 votes
by (47.2k points)

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.

0 votes
by (140 points)


  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.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers


104k users

Browse Categories