DB Alias Tab for SQL Server

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.

Load Request Editor with DB alias for SQL Server as the active tab. The elements are described in the following text.
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.
Constraint Non-Disablement Warning dialog that is displayed if referential integrity constraints are not disabled.
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.



Feedback