[Webinar] Streamline your web hosting managementRegister Today


How to find/edit SSIS packages in SQL Server 2008

Posted on 2010-03-30
Medium Priority
Last Modified: 2013-11-10

In SQL Server 2008, I have created a SSIS package by using the "Import Data" wizard.  I know that this package exists because when I try to create a job, I am able to reference this SSIS package when creating one of the job steps.

However, I am unable to find this SSIS package in the Object Explorer in SQL Server Mgmt Studio.  Anyone know where I can look?

Question by:hpsuser
  • 2
LVL 16

Accepted Solution

Megan Brooks earned 1500 total points
ID: 29157087
It saves it wherever you tell it to. If you saved it to a file, try looking in your My Documents directory.

You could also create another similar (same source & destination) package using the wizard and look to see where it offers to save the package by default.

If you saved to SQL Server, you are not going to find a file. In that case you can see the package by connecting to the SSIS server ("Integration Services" option). Again, creating a similar package using the wizard can show you which SQL Server  was used by default.

Author Comment

ID: 29810502
Thanks, it now appears the problem has to do with the service not being started and/or logins not working, so I think the problem needs to be worked from that angle with our DBA's.

Author Closing Comment

ID: 31709152
Thanks, I think the problem has to do with the service not being started and/or login issues.  Need to work the issue with our DBA's.
Thanks for responding!

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question