Reporting Services RSExecutionLog - 2008R2 - scripts and packages

Question

We are upgrading from SQL2000 to SQL2008R2.  Several years ago we had someone install and develop reports for the RSExecutionLog Database - SQL2000.  That developer no longer works here and I've spent several days understanding the current process and looking to upgrade to the 2008R2.  I've downloaded several items from CodePlex trying to find the createtable.sql script and the RSExecutionLog_Update.dstx packages.  When I install the downloads, these files are not part of the download. 

Does anyone know where I can get the latest code to be able to develop these reports on 2008R2?  It looks like I should be able to upgrade, but the files just don't exist. 

Thanks in advance

Answer 1

You should check this : http://sqlserversamples.codeplex.com/releases/view/30803

Make sure to download the SQL2008.All_Product_Samples_Without_DBs.zip file and you'll find what you're looking for on Server Management Sample Reports\Execution Log Sample Reports.

Just make sure to change the createtables.sql script by extending the statuscodes.status field to nvarchar(40) instead of nvarchar(32). This was compatible with 2005 version of reportserver database exutionlog table. On the otherwise you could see your ETL package failing

Answer 2

there are two samples for SQL Server 2008 and SQL Server R2, you should download Samples for SQL Server 2008, Since it can be installed in both SQL Server Databases and it contains Complete sort of application and scripts  you need.

you should download aformentioned samples from here http://sqlserversamples.codeplex.com/releases/view/30803

Good Luck