CODEWITHSUNDEEP
sql-server-2008ssis
Christopher
Christopher

Reputation: 10627

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.

Upvotes: 26

Views: 67900

Answers (4)

Andy Bozek
Andy Bozek

Reputation: 71

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

Upvotes: 2

RGME
RGME

Reputation: 104

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.

Upvotes: 1

Justin Niessner
Justin Niessner

Reputation: 245449

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.

Upvotes: 6

Daniel DiPaolo
Daniel DiPaolo

Reputation: 56408

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.

Upvotes: 22

Related Questions