|
Introduction |
|
Using SQL File Import |
|
|
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.
You
then need to enter a name for the task, and choose the frequency to
run this task.
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).
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.
You
can then use the Windows Task Scheduler to edit any of the task
settings in the future.
|