We have multiple SSIS developer teams working on different size and type of projects. How can it be ensured that good patterns (for error-handling, logging, configurations, FTP, emailing etc.) created by one team are shared with other teams? The goal is to reduce the time spent in design+development and long term maintainability by following common patterns. Thanks! Aalam | Blog (http://aalamrangi.wordpress.com)

You can create templates for different kind of packages (loading a dimension, importing an excel file, loading a fact table) and use them in your projects: http://support.microsoft.com/kb/908018 What I usually do is give a workshop in the beginning of the project with all the developers as attendees. There you can explain the patterns and best practices used in the development of SSIS packages.MCTS, MCITP - Please mark posts as answered where appropriate.

Create templates like Koen mentioned and adopt best pratices.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

I've created a TechNet Wiki page to gather SSIS patterns. Please feel free to browse and/or add! http://social.technet.microsoft.com/wiki/contents/articles/10844.ssis-design-patterns.aspx Thanks!Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers. Thanks! Aalam | Blog (http://aalamrangi.wordpress.com)