dewizard:target_database_specific_parameters

Target Database Specific Parameters

Ensure that any constraints on the destination table are checked during the bulk copy operation. By default, constraints are ignored.

Specify that there are values in the data file for an identity column.

Specify that any columns containing a null value should be retained as null values, even if a default value was specified for that column in the destination table.

Specify the number of rows in a batch. The default is the entire data file.

The following values for the Batch size property have these effects:

If you set Batch size to zero, the data is loaded in a single batch. The first row that fails will cause the entire load to be cancelled, and the step fails.

If you set Batch size to one, the data is loaded a row at a time. Each row that fails is counted as one row failure. Previously loaded rows are committed.

If you set Batch size to a value greater than one, the data is loaded one batch at a time. Any row that fails in a batch fails that entire batch; loading stops and the step fails. Rows in previously loaded batches are either committed or, if the step has joined the package transaction, provisionally retained in the transaction, subject to later commitment or rollback.

The box above allows you to specify Conventional and Direct path loading

Note:

Option ‘Commit every 100 records’ works only for Oracle conventional path loading 

When Commit is set to “every statement” import works as follows:

Execute SQL before statement
Commit
Insert one record 
Commit
Insert one record 
Commit
Execute SQL after statement
Commit

Note:

Most databases support this way of loading data including files

When Commit is set to “once import is completed” import is executed inside one big transaction:

Start transaction
Execute SQL before statement
Insert one record 
Insert one record 
More inserts
Execute SQL after statement
Commit transaction

Note:

Not all databases support this way of loading data. 
It also possible to use ODBC connection strings for both Source and Target connections. 
For example for MS SQL Server connection string is:
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPass;

More information about connection strings can be found at http://www.connectionstrings.com

Note:

Leave user name and password blank and provide it within connection string

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizard/target_database_specific_parameters.txt
  • Last modified: 17/09/2018 09:43
  • by admin