We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Load a file into a temporary table using extended permitted folders
Identical to FileToTempTable but uses the extended permitted folders list for the file permission check. Use this variant when the source file is in a location that requires elevated folder access (such as a network share or integration folder).
| Parameter | Description |
|---|---|
| cmd | full path to the source file |
| Argument 0 | temp table name to create and populate |
| Argument 1 | file format: TAB, COMMA, or blank for XML |
| Argument 2 | DEBUG to enable row-by-row debug mode for diagnosing bad XML records |
| Argument 3 | quoting: 0 = data is not quoted, 1 = data is already quoted, 2 = quote data before parsing |
| Argument 4 | character encoding: utf8 (default) or ascii |
FileToTempTable2 "full path to the source file", "temp table name to create and populate", "file format: TAB, COMMA, or blank for XML", "DEBUG to enable row-by-row debug mode for diagnosing bad XML records", "quoting: 0 = data is not quoted, 1 = data is already quoted, 2 = quote data before parsing", "character encoding: utf8 (default) or ascii"