Which option should we choose to import SSIS Package ?

#1

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

#2

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

"Patrick" wrote:

Quote:

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
.

#3

Dear Todd,

Many thanks for your advice.

Patrick

On 24/02/2010 12:45 AM, Todd C wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Which option should we choose to import SSIS Package ?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Which option should we choose to import SSIS Package ? - 02-23-2010 , 06:05 AM

RE: Which option should we choose to import SSIS Package ? - 02-23-2010 , 08:45 AM

Re: Which option should we choose to import SSIS Package ? - 02-23-2010 , 03:46 PM