tags:

views:

102

answers:

2
+1  Q: 

Where are SSIS Packages Saved?

I right clicked on a Database in the object explorer of SQL Server 2008 Management Studio. I went to Tasks > Import Data, and imported some data from a flat text file, opting to save the package on the server.

Now how the heck do I get to the package to edit or run it again? Where in SQL Server Management Studio do I go? I've expanded everything and I can't find it. It's driving me nuts.

+1  A: 

If you connect to the Integration Services instance on the server (different choice in the dropdown from "Database Engine" when you connect in SQL Server Management Studio), they'll be under the MSDB folder under Stored Packages.

Daniel DiPaolo  2010-04-29 21:00:00
I tried this. There are two root folders. Running Packages and Stored Packages. Both of those and every subfolder is empty.However, if I go through my import process again, it will tell me the package exists and ask if I want to overwrite, so I know they must be on the server!I double-checked and I am connecting to the correct server.
Chris  2010-04-29 21:47:01
Oh wait I do see them there! But there is no option to Edit. Just Import, Export, Upgrade, etc.
Chris  2010-04-29 21:49:34
You can't edit them on the Integration Services instance itself. You'll need to export them and then open them up in BIDS (Business Intelligence Design Studio, the Visual Studio flavor for BI), and then you can redeploy the package.
Daniel DiPaolo  2010-04-29 22:09:35
+1  A: 

When you start management studio and connect to a database, make sure you have the server type set to Integration Services instead of Database Engine.

Justin Niessner  2010-04-29 21:01:02
Wrong product - it's Integration Services.
Todd McDermid  2010-04-29 23:09:04
@Todd McDermid - Doh! No more posting on StackOverflow under the severe influence of coffee for me. Updated my post.
Justin Niessner  2010-04-29 23:21:50

related questions

In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?
Advantages of MS SQL Server 2008 over MS SQL Server 2005?
SqlDataReader.HasRows returns false since SQL 2008 upgrade
How do I set the login info for SQL Server 2008 in Entity Framework?
Move SSIS Packages from SQL Server 2005 to 2008.
Installation problem sql server 2008
How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?
How to use DataMining feature of SQL Server 2008 with ASP.Net
SSAS Cube Browsing not working after SQL 2008 CTP uninstall
Hooking up Reporting Services 2005SP2 to SQL Server 2008
New Date/Time data types in SQL 2008
Can SQLExpress 2005 and 2008 be installed on same machine without issue?
Any reason to have SQL Server 2005 and 2008 installed on same machine?
Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008
How do I get the full name of the current user from a SQL Reporting Services 2008 report?
How do I fix a Cross language installation problem in SQL Server 2008?
Upgrade MSDE to SQL Server 2008
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
SQL Server 2008 Reporting Services Report Definition Customization Extensions
Moving SQL2005 app to SQL2008
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Can I use SQL Server Management Studio 2005 for 2008 DB?
SQL 2008 Dialect Support for NHibernate
SQL Server 2008 vs 2005 Linq integration
SQL Server 2005 and 2008 on same developer machine?