It is very easy to use the Windows Scheduler to schedule jobs for
importing XML into SQL Server. We will use the Exult command line
Exultcmd.exe for this purpose.
|3.2.1 Adding a task to the Windows Scheduler|
|3.2.2 The Scheduled Tasks Wizard|
|3.2.3 Select Exultcmd.exe for scheduling|
|3.2.4 Specify time and frequency of execution|
|3.2.5 Specify user name and password|
|3.2.6 Scheduled Task Created|
|3.2.7 Advanced Task Settings|
|3.2.8 Advanced Scheduling|
|3.2.9 Advanced Settings|
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.