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]​
​

MSCEWI4022

MSCEWI4024