BI Templates missing in Visual Studio

After doing a installation of all the necessary tools, SQL Server, Visual Studio I suddenly realized that my Business Intelligence Templates were missing in Visual Studio. Here is how to restore them.

Start Visual Studio and go to Tools->Import and Export Settings…

image

Select Import selected environment settings. Click Next.

image 

Select “Yes, save my current settings” and click Next.

image 

Select the Business Intelligence Settings option and click Next.

Now, my templates were restored.

image

Error emitting ‘System.Reflection.AssemblyVersionAttribute’ attribute — ‘The version specified ’1.0.080928.1′ is invalid

 

You might have seen this error when using the Microsoft AssemblyInfo Task utility. The reason for this error is that the build number version info cannot be greater than 65535. And when using the default settings in the AssemblyInfo Task configuration file which is yyMMdd:

   1: <AssemblyBuildNumberFormat>yyMMdd</AssemblyBuildNumberFormat>

For a date info of 2008-09-28 the build version number would be 1.0.080928.x , and 80928 is greater than 65535, which would generate the error in question.

 

In order to fix this you will have to edit the Microsoft.VersionNumber.targets file which is located in the C:Program Files (x86)MSBuildMicrosoftAssemblyInfoTask folder. Or C:Program FilesMSBuildMicrosoftAssemblyInfoTask on 32bit installations.

 

You will find the AssemblyBuildNumberFormat element in two places. Edit those to another format, for instance 01MMdd and save the file.

   1: <AssemblyBuildNumberFormat>01MMdd</AssemblyBuildNumberFormat>

 

You will then have to reset the version in the AssemblyInfo.cs file(s) to v1.0.0.0, save the files, restart Visual Studio and rebuild the solution.