BulkCopy Properties


Property Description

Application
    Application
    Write: No
The Application object.
ColumnDelimiter
    String
    Write: Yes
The character(s) that are used to separate columns in the data file. Set this property only if the DataFileType property has been set to SQLOLEDataFile_SpecialDelimtedChar.
DataFilePath
    String
    Write: Yes
The full path and filename of the data file. It is a destination file if it is passed to the Table.ExportData or View.ExportData method. It is a source file if it is passed to the Table.ImportData method.
DataFileType
    SQLOLE_DATAFILE_TYPE
    Write: Yes
The type of the data file.
ErrorFilePath
    String
    Write: Yes
The full path and filename of the error file. This file will contain any bulk copy errors that occur.
FirstRow
    Long
    Write: Yes
The first row to copy. It is the first row of the Table or View if it is passed to the Table.ExportData or View.ExportData method. It is the first row of the data file if it is passed to the Table.ImportData method.
FormatFilePath
    String
    Write: Yes
The full path and filename of the bulk copy format file, which is used to describe the format of the data file. Set this property only if the DataFileType property has been set to SQLOLEDataFile_UseFormatFile.
ImportRowsPerBatch
    Long
    Write: Yes
The number of rows copied during each committed batch.
IncludeIdentityValues
    Boolean
    Write: Yes
Determines if values can be inserted into the identity column of a Table. If True, the IDENTITY_INSERT option is turned on before a Table.ImportData bulk copy is started. If False, values cannot be inserted into the identity column of a Table.
LastRow
    Long
    Write: Yes
The last row of the Table or View to copy. It is the last row of the Table or View if it is passed to the Table.ExportData or View.ExportData method. It is the last row of the data file if it is passed to the Table.ImportData method.
LogFilePath
    String
    Write: Yes
The full path and filename of the log file. This file will contain bulk copy statistics and any non-bulk copy messages from SQL Server that are received.
MaximumErrorsBeforeAbort
    Long
    Write: Yes
The maximum number of bulk copy errors that can occur without stopping the bulk copy. If more errors occur, the bulk copy will be stopped.
Parent
    Application
    Write: No
The Application object.
RowDelimiter
    String
    Write: Yes
The character(s) that are used to separate rows in the data file. Set this property only if the DataFileType property has been set to SQLOLEDataFile_SpecialDelimtedChar.
SuspendIndexing
    Boolean
    Write: Yes
Determines if existing indexes (not including those that enforce primary key or unique constraints) are suspended during the Table.ImportData bulk copy. If True, these indexes are dropped before the bulk copy is started and recreated after the bulk copy is completed. If False, no changes are made to indexing.
TruncateLog
    Boolean
    Write: Yes
Determines if the transaction log is truncated. If True, the transaction log is truncated before a Table.ImportData bulk copy is started. If False, the transaction log is not truncated.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UseBulkCopyOption
    Boolean
    Write: Yes
Determines if the SELECT INTO/BULKCOPY option is turned on. If True, and if the SELECT INTO/BULKCOPY option is turned off, the option is turned on before a Table.ImportData bulk copy is started, and it is turned off after the bulk copy is complete. If False, no adjustments to the SELECT INTO/BULKCOPY option are made.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.