1. Verify that Data Transformation Services 2000 Runtime

1. Verify that Data Transformation Services 2000 Runtime is installed on the computer running SQL Server 2005. Look for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinndtsrun.exe If the file is missing, choose Add or Remove Programs in the Control Panel to install Microsoft SQL Server 2005 Tools. This installs the Data Transformation Services 2000 Runtime. 2. Create a database for the Report Execution data. In SQL Server Management Studio, in Object Explorer, create a new database that the DTS package can use as its destination database. For the database name, use the name RSExecutionLog. 3. Add tables to the database. To add tables to the database, select RSExecutionLog from the Available Databases list box on the toolbar in SQL Server Management Studio (see Figure 12-11). Choose File.Open and then click File. Browse to the following file: C:Program FilesMicrosoft SQL Server90Tools\90ToolsReporting ServicesExecution LogCreatetables.sql Figure 12-11: The new database RS Execution Log and the script createtables .sql ready to execute to create the execution log tables in a database. Chapter 12: Managing and Administering Your Reports 241

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost JSP Web Hosting services

Bookmark the permalink.

Comments are closed.