Where are SSIS Packages Saved?

Question

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.

Answer 1

You can find the file path in SSIS under "properties" of the package. right click the package in solution explorer > full path in the properties window

Answer 2

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.

Answer 3

They are stored on the file system as .dtsx files or in msdb.dbo.sysssispackages. If they are stored in the database you can run them with sql server management studio by connecting to integration services. To edit them, you'll need to export to the file system (.dtsx file) then edit.

Answer 4

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.