Links
Comment on page

MSCEWI4023

Bulk option not supported

Severity

Low

Description

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:

Code Example

Input Code:

BULK INSERT #PCE FROM 'E:\PCE_Look-up_table.txt'
WITH
(
FIELDTERMINATOR ='\t',
ROWTERMINATOR ='\n',
FIRE_TRIGGERS
);

Output Code:

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
;

Recommendations

  • Check the current data/format of the file you are going to import.
  • If you need more support, you can email us at [email protected]