Comment on page
MSCEWI4023
Bulk option not supported
Low
This EWI is added when some option in a
BULK INSERT
could not be mapped. The translated bulk options should be reflected as FILE FORMAT
options. Example:BULK INSERT #PCE FROM 'E:\PCE_Look-up_table.txt'
WITH
(
FIELDTERMINATOR ='\t',
ROWTERMINATOR ='\n',
FIRE_TRIGGERS
);
CREATE OR REPLACE FILE FORMAT FILE_FORMAT_00000000000
FIELD_DELIMITER = '\t'
RECORD_DELIMITER = '\n'
-- ** MSC-WARNING - MSCEWI4023 - 'FIRE_TRIGGERS' BULK OPTION COULD NOT BE TRANSFORMED TO ANY OF THE EXISTING FILE FORMAT OPTIONS **
--FIRE_TRIGGERS
;
- Check the current data/format of the file you are going to import.