i personally like the file system. it's generally easier on me since i'm normally authoring the jobs and don't have hundreds of packages to manage. if i did have hundreds of packages to manage and i didn't author, i might prefer the server. here are some great blog posts about this subject.
pros and cons of both
mostly pros for file system
As a bonus during my research I came across this blog which appears to detail an experience of trying to continuously integrate a data-mart among other things.
http://mgarner.wordpress.com/2006/08/31/automating-ssis-deployment/
http://mgarner.wordpress.com/2006/09/24/builddb-open-source-tool-for-the-agile-sql2005-database/
http://mgarner.wordpress.com/2006/10/22/ndataunit-unit-testing-tool/
posted @ Saturday, May 05, 2007 12:38 AM