Transfer process for bulk-copy and express transfer from the client application through the access service to the database.
The client application initiates a transfer request.
The access service receives the transfer request and executes the sourceselectstatement against the source database to retrieve the schema of the result set, including column datatypes, length, precision, and scale.
If either of these tests fails, the access service stops processing the transfer and issues an error message.
If the transfer statement includes the with replace or truncate clause, the access service deletes data in the target table, provided the user ID of the person executing the request is authorized to do so. If the user ID is not authorized, the transfer fails.
The access service maps the columns from the result set to the columns in the target table in the same order. The access service attempts to insert NULL values (if allowable) in all columns in the target table that does not have corresponding columns in the result set.
The access service prepares an insert or equivalent bulk load statement for execution against the target table.
The transfer continues processing. If the SendWarningMessages property is set to yes, the access service sends a warning message to the client application.