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.
A:
This tutorial will answer this question : SSIS packages in SQL Server Management Studio.
Moayad Mardini
2009-05-20 15:47:11
+1
A:
The wizard likely created the package as a file. Do a search on your system for files with an extension of .dtsx. This is the actual "SSIS Package" file.
As for loading it in Management Studio, you don't actually view it through there. If you have SQL Server 2005 loaded on your machine, look in the program group. You should find an application with the same icon as Visual Studio called "SQL Server Business Intelligence Development Studio". It's basically a stripped down version of VS 2005 which allows you to create SSIS packages.
Create a blank solution and add your .dtsx file to that to edit/view it.
dm
2009-05-20 15:49:53
A:
Are you trying to import an older SSIS project like an old DTS version into SSIS 2005/2008?
Andrew Jahn
2009-05-20 15:49:57
+3
A:
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.
Lunchy
2009-05-20 15:50:51
This was the answer, but I had a firewall issue that was blocking me from connecting from my local PC; on the server I could see everything just fine.
Caveatrob
2009-05-20 17:39:41