MSCEWI4023

Bulk option not supported

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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]