Expert SQL Server™ 2005 Integration Services

8.3. Creating a Package Template

When you go through the trouble of developing the perfect shell or blueprint of a package to use repeatedly, you don't want to have to do it again. Templates in SSIS can help you prevent having to do repetitive boilerplate work inside the package (such as setting up your configuration, event handlers, logging, or annotation). They also enforce the same best practices across your entire development team, and strengthen time-to-market and cross-training. As developers move from project to project, they'll be able to read another developer's package.

To create a template, you must create the package that you want to use as a template, then copy the package to the following directory:

%ProgramFiles%\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransfor
mationItems

The %ProgramFiles% directory is an environment variable that redirects you to the proper drive for your Program Files folder (and would typically resolve to c:\Program Files).

When the file is copied into each developer's template folder, they can use the template by right-clicking the project and selecting Add New Item. Then, they select the file name for the template. A new package will be created that is an exact duplicate of the one created earlier.

The problem with this newly created package being exactly like the original package ...