Templates in BIDS or SSDT are a great time-saving feature for both SSIS and SSRS. They also promote consistency across all developed reports and integration services packages. Finding the correct path to store templates can be a challenge, which is what I hope this blog will illustrate. Below I listed a quick reference where to store your templates.
Templates Paths for SQL Server 2005
%Program Files%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\[Template Type]
Templates Paths for SQL Server 2008 and 2008 R2
%Program Files%\ Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\[Template Type]
Templates Paths for SQL Server 2012
%Program Files%\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\ProjectItems\[Template Type]
SSIS = DataTransformationProject
SSRS = ReportProject
- These paths are based on default installs, you may need to adjust according to your install location.
- The %Program Files% will be either Program Files or Program Files (x86), depending on if you are using a 64bit architecture.
- You will need to replace the [Template Type] with DataTransformationProject for SSIS and ReportProject for SSRS