Home
SQL File Import online help Prev Page Prev Page
Introduction
About SQL File Import
Version history
Contact us
Supported database engines
Using SQL File Import
Home page
Task Wizard
Select source data
Files as source data
CSV source data files
Excel source data files
Enter file search patterns
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
Database scripts
Select table to upload into
Map data to table columns
Review script results
Transaction options
Logging options
Finalise
Run task
Scheduling a task
Options
Scripting
Global variables
OnBeforeUpload function
OnAfterUpload function
Support functions
Data functions
Log functions
String functions
Date and time functions
Date-Time format strings
File functions

Scheduling a task

To run an import task non-interactively, the SQL File Import command line interface (SQLFileImportCmd.exe) is used. The first parameter must be the name of the import task file.

schedule_01a  
 
You then need to enter a name for the task, and choose the frequency to run this task.

schedule_02  
 
After you have set up the relevant schedules, you will need to enter the account details of a user that has permission to run the import. This user must also have permission to access your database if you are using Windows authentication as the logon method (e.g. for SQL Server instances).

schedule_04  
 
Once that is completed, SQL File Import will display a summary of the task settings. Click Finish to save the task into the Windows Task Scheduler.

schedule_05  
 
You can then use the Windows Task Scheduler to edit any of the task settings in the future.

schedule_09a