Using Microsoft SQL Server 2000 Data Transformation Services to Import Log Files
Using Microsoft SQL Server 2000 Data Transformation Services to Import Log Files
The event logging information recorded in .etl files can be viewed and analyzed in the Speech Application Log Analysis Tools, described in the topic Detailed Analysis Tools. First, the data in the .etl files must be imported to databases designed for these tools.
Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets you extract, transform, and consolidate data from disparate sources. DTS configurations are saved as packages, which can be saved to Microsoft SQL Server, SQL Server 2000 Meta Data Services, a structured storage file, or a Microsoft Visual Basic file. DTS is a component included with SQL Server Enterprise Manager. The DTS task used in the following procedure is installed along with the Speech Application Log Analysis Tools.
Use DTS to create both the Speech Application Reports database and the Call Viewer database in a single operation; or use it to create either of these two databases individually. As an alternative, if SQL Server Enterprise Manager is not available, use the MSSLogToDatabase command-line tool to create these databases as described in the topic Using the MSSLogToDatabase Tool (MSSLogToDatabase.exe) to Import Log Files.
For More Information
To |
See |
|---|---|
Get more information on creating databases. |
|
Get more information on scheduling DTS imports. |
|
Get more information on DTS security. |