How to consolidate and share SSIS patterns among multiple teams?

Question

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)

Answer 1

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.

Answer 2

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

Answer 3

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)