Which option should we choose to import SSIS Package ?

[Patrick]

We are new to SQL Server 2005. When we import SSIS Package, there are 2
options - File System or MSDB file.

Which one should we choose ?

Thanks

[Todd C]

In my opinion (which is worth exactly what you are paying for it ), you
should go with MSDB storage. The packages get saved into the MSDB database
and are backed up with the database.

With File system, you potentially leave yourself open to someone editing a
package deployed there.
--
Todd C
MCTS SQL Server 2005

Post by Patrick
We are new to SQL Server 2005. When we import SSIS Package, there are 2
options - File System or MSDB file.
Which one should we choose ?
Thanks
.

[Patrick]

Dear Todd,

Many thanks for your advice.

Patrick

Post by Todd C
In my opinion (which is worth exactly what you are paying for it ), you
should go with MSDB storage. The packages get saved into the MSDB database
and are backed up with the database.
With File system, you potentially leave yourself open to someone editing a
package deployed there.