ansaurus

Question

SSIS packages within SQL Server Agent and File Server: advantages - disadvantages

Answer 1

A:

The following site provides a description of the pros and cons of each: http://pragmaticworks.com/community/blogs/nayanpatel/archive/2008/11/13/what-are-the-advantages-disadvantages-of-storing-ssis-packages-to-msdb-vs-file-system.aspx

This is summarised in the following table:

Functionality        Best in File System    Best In MSDB
Security                                    Yes
Backup and Recovery  Yes    
Deployment           Yes    
Troubleshooting      Yes    
Execution Speed      Yes                    Yes
Availability         Yes

Where i work we have a number of different shipping environments, and shipping tool. We also have the need to pass in connection strings (for each shipping stage), so have to worry about other means by which we encrypt the data. Placing everything in the file system is so much easier for us.

James Wiseman 2009-10-23 08:51:50

Noticed your accept rate of 40%. If this helps, can you accept the answer?

James Wiseman 2009-10-23 08:53:34

Stop chasing points instead help build the community. Points will follow... :)

Faiz 2009-10-23 19:28:46

That's me told ;-) Although, I would have thought that encouraging folk to accept answers was a community building activity. I've always tried to encourage people to do this regardless of whether or not I answered the question.In all, i've answered 88 questions, so I think your comment was a little unfair, even if it was intended light-heartedly.

James Wiseman 2009-10-26 12:03:28

ansaurus

tags:

views:

answers:

SSIS packages within SQL Server Agent and File Server: advantages - disadvantages

related questions