deploying ssis to file system or server

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/