SYSPRO have a utility to test the BULK INSERT routine as used by the MAN modules.
This may be used to resolve the following common file status’s:
37 – Invalid permissions
9-??? – Invalid folder (??? denotes any 3 character numeric value e.g. 9-009)
On the SYSPRO Main Menu:
Utilities \ SQL Server Utilities \ Diagnostic Query (or Run Program “IMPDG6”)
Select the “Function” option in the program menu and “Test Bulk Insert command…”
Select “OK” to allow test to run. If all is well, you should receive a success message.
If the folder specified in the “Temporary folder:” is invalid, has inadequate permissions or insufficient space available, an associated message will be displayed.
Invalid folder specified:
Inadequate permissions:
Failure message:
Posted in: Manipulation, Technical