Hi @SteveSanda-0188 If you have an Azure File Storage instance deployed, you can complete one of the following:
You should ensure you are aware of the prerequisites, especially port 445.
The issue is that customers desire to run the data load with the following, which is not supported:
LOAD DATA LOCAL
INFILE "\\\\xxxxxxx.file.core.windows.net\\importfiles\\import.txt"
INTO TABLE import_db.import_table
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
But the same can be expressed by a local drive letter:
LOAD DATA LOCAL
INFILE "Z:\importfiles\import.txt"
INTO TABLE import_db.import_table
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
Regards,
Mike