SSIS location

Question

Where does SQL Server store the SSIS packages?

Answer 1

I use SQL Server 2005 in combination with Visual Studio 2005. So all my SSIS projects by default will be at

C:\Documents and Settings\santosh\My Documents\Visual Studio 2005\Projects

Let me know if you have your SQL Server set up in a different environment or if you have made changes to your Visual Studio options.

If you dont find your projects at above mentioned location, look at the defined default projects path in Tools>Options in Visual Studio.

This should help.

Answer 2

Depending on how you choose to deploy them, they are either stored within the MSDB database or on the file system. Here's how you do both:

• File System
• Server (msdb)

Answer 3

By default, the physical location of the ssis package is at: C:\Program files\Microsoft SQL Server\90\Dts\packages

once you deploy it, you will find them in MSDB database in the sqlserver.