There's nothing special in my template, and you would have to rewrite most of it to suit your environment anyway. The important point is that you want to use a template instead of configuring blank packages from scratch. First figure out how you want to do configuration, logging, and error handling, then create a package with these settings and save it for reuse. The other important point is that they aren't truly templates, at least not in the sense of Office document templates. Word or Excel templates cause a new document to be created, Integration Services simply copies the template file and leaves it up to you to change the Name and ID properties.

Microsoft has some info on package templates (not nearly as elaborate as the template functionality of other Visual Studio languages)

http://msdn.microsoft.com/en-us/library/ms345191(SQL.90).aspx

http://support.microsoft.com/kb/908018

Jamie Thomson has a blog entry with a downloadable template package, the next link has an interesting error handling template.

http://blogs.conchango.com/jamiethomson/archive/2007/03/11/SSIS_3A00_-Package-Template.aspx

http://weblogs.sqlteam.com/jamesn/archive/2008/04/30/60582.aspx