I like to try and create templates for each type of project that I am working on. This takes the work out of having to do the same tasks over and over again when it comes to creating new items (Reports Services Reports, Integration Services Packages). So where do you place those templates that you have created? I’m glad you asked:

SSIS Templates go here:

%Program Files%Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesProjectItemsDataTransformationProjectDataTransformationItems

SSRS Templates go here:

%Program Files%Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesProjectItemsReportProject