Purpose: 

The Purpose of This article describes how to use the DTS Import/Export Wizard to import data to Microsoft SQL Server database named Event_Viewer_Record from an exported file of Event Viewer.

Exporting Application Log To a Text File

1. Launch Event Viewer from StartèProgramsèAdministrative Toolsè Event Viewer.

2. Right Click System logèExport List to export this data in a Text file.

3.       Save this file with a proper name like System Log.

Importing Text File to Database:

4. Start SQL Enterprise Manager, select Data Transformation Services and click the Import Data option to launch Data Transformation Services Import wizard.

5.       Click Next to Start the Data Transformation Import/Export Wizard.

6. Select Text File as a data source, enter the path of your previously saved Event Viewer file and click next.

7. Select the proper file format of your saved file or leave the default settings (Recommended).

8. Select the desired column delimiter.

9. Select your database provider (Destination), database server and database name (Event_Viewer_Record) where you want to import data in the next phase.

10. Select your source and destination tables.

11. Run this import export process immediately or define a scheduling for this process. Similarly, you can also save this process as a DTS package.

12. Finally confirm your whole wizard process by reviewing the Summary.

13. After Successfully completing this wizard, you will receive this type of message.

14.   At last, click Ok and then click Done to end this process.

15.   Your System log has been successfully imported to an SQL database.

Top