Optimizing Microsoft SQL Server Reporting Services: Execution Log Reporting: Preparation as a Data Source

31. Select Package —> Properties from the DTS Designer main menu, as shown in Figure 18.




Figure 18: Select Package —> Properties

The DTS Package Properties dialog appears, defaulted to the General tab.


32. Click the Global Variables tab.

33. Click the Value box that corresponds to the Global Variable named sConfigINI.

34. Input the full path with file name for the rsexecutionlog_update.ini file that we copied, along with the other files provided by Reporting Services for Execution Log reporting, into our SSP-RS001 folder, in the Preparation phase of our exercise.


As an example, for my own environment, I enter the following path:


E:DATARDBMS_DATAMSSQLDataReporting_Services_ProjectsSSP-RS001RSExecutionLog_Update.ini


The DTS Package Properties dialog – Global Variables tab appears, with partially visible sConfigINI Value box entry, as depicted in Figure 19.




Figure 19: Configuration File Value Box Entry (Partially Visible)

35. Click OK to accept our addition, and to close the DTS Package Properties dialog. We return to the DTS Designer.


36. Select Package —> Execute from the DTS Designer main menu, as shown in Figure 20.




Figure 20: Select Package —> Execute

The DTS Package executes, displaying step-by-step status messages within the Executing DTS Package viewer that appears next. Once the process is completed, we are greeted with a Package Execution Results message box, indicating successful completion, as depicted in Figure 21.




Figure 21: Success is Indicated – With Step-by-Step Statuses

37. Click the OK button on the Package Execution Results message box to close it.

38. Click Done to close the Executing DTS Package viewer.


We return to the DTS Designer.


39. Select Close under the Enterprise Manager icon in the upper left corner of the DTS Designer, as shown in Figure 22 (NOT Exit under File in the adjacent main menu).




Figure 22: Closing the DTS Designer to Return to Enterprise Manager

 

Continues…



Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |