SQL Server Integration Services (SSIS) as a technology has matured enoughthat design patterns can be established and compiled for reference at one source. This will cut down on estimation, development and maintenance of SSIS projects. This wiki will catalog books, blog and MSDN articles that are related to reusable patterns in SSIS development. Technical author and speaker, Matt Mason, talks about patterns and frameworks on his website -

Consistent Design Patterns and SSIS Frameworks http://www.mattmasson.com/2013/04/consistent-design-patterns-and-ssis-frameworks/

Further Reading http://www.mattmasson.com/category/design-patterns/


Articles/Blog Posts/Wiki

Naming Patterns

Template Patterns

If a new package is created by copying from an existing package or a package template, verify that the name and the GUID of thenew packageis different from thesource package. If they are the same then it will be difficult to differentiate between the two packages in thelogs.

Annotations with Customization

  • Hidden SSIS Features: Word Wrapping Your Annotations And More By Paul Blackwell, 2010/12/20 Annotations in SSIS packages till SQL Server 2008 R2 are stored in binary format. The binary formatputs many restrictions on customizing the properties of annotations. The article shares a lot of information about the implementation and indirect customization of this feature. http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/71516/

Variables and Expressions Patterns

Configuration Patterns

Data Load Patterns

SSIS Performance DesignPatterns

DB2 Patterns

Estimation Patterns

Other Articles

Case Studies

Use the Advanced Search on the Case Studies website and use 'SQL Server Integration Services' as the keyword. You can also subscribe to the RSS feed of the results - http://www.microsoft.com/casestudies/ddi/rss.aspx?LangID=46&G1=2643,24045,24046,30966&TN=1

See Also