Use the DB Alias tab to define the parameters needed for the Microsoft SQL Server
loader. The availability
of certain options and fields might be dependent upon your entries
for related options and fields on the tab.
- Mode
- Insert
- Insert the rows from the source file into the destination
tables. If the primary key values match, duplicate rows are discarded
or inserted into the error file (if specified).
- Replace
- Clear all data
in the destination tables and replace
with rows from the source file.
- Error File Options
- Create
- Create a discard file
to use during the load
process.
- Max Errors
- The number of rows (up to 999999999) that the loader
can discard because of errors. Stop processing when the specified
number of rows is discarded.
- To end the process
if a single row is discarded,
specify 1 as the maximum.
- To allow an unlimited
number of rows to be discarded,
specify zero (0) or leave blank.
- Options
- Perform Load
- Run the loader automatically after file conversion.
Options to disable triggers and constraints apply. Clear to convert
the data and create a BAT file. To run the loader, you must edit the
BAT file to include password information, ensure that destination
tables are empty, and run.
- Delete files if Successful
- Delete
load files after the loader completes successfully. Fast load confirmation is not available.
- Load When Source is Empty
- Complete the load if a table to be loaded contains no rows, deleting
any rows from the target. If not selected, empty source tables are
skipped.
- Delete files if
Failure
- Select to delete the load files if the
loader does
not complete successfully. Fast load confirmation is not available.
- Disable
Triggers
- Never
- Never disable
database triggers for the loader.
- Always
- Disable database triggers
during the load process
and re-enable triggers when the process is completed.
- Prompt
- Display the Disabling Trigger/Constraint
Confirmation dialog to list tables with associated triggers.
Right-click the Status After Process column
to enable or disable the corresponding trigger or constraint after
the load completes.
- Disable
Constraints
- Never
- Never
disable referential integrity constraints for the loader. This option
causes a warning message when you run the loader.
- Always
- Disable constraints during the load process and
re-enable constraints when the process is completed.
- Prompt
- Display the Disabling Trigger/Constraint
Confirmation dialog to list tables with associated constraints.
Right-click the Status During Process column
to enable or disable the corresponding trigger or constraint during
the load. Right-click the Status After Process column to enable or disable the corresponding trigger or constraint
after the load completes.
- Additional Loader Parameters
You can augment
the loader arguments created automatically with additional
loader parameters. The parameters you create are appended to the list
created automatically, but are not validated before starting the loader.
For valid operands, see the database loader documentation. If additional
loader parameters are forced from within product options, you cannot
modify them.
- Use NT Authentication
Supply the -T parameter to instruct the loader
to use the network logon as user ID and password. Otherwise, -U and
-P parameters (user ID and password) are used when starting the loader.
- Work Path for interim files
Default directory path for temporary loader files.