True = Limits both import and export to only one operation at a time, by locking on an object in the DIXF Service. This only applies to Excel files – the lock is ignored for all other data types.
False = No locking. Default behavior.
Process = Most issues we have with Excel and SSIS appear to corrupt memory in the current process (i.e. the DIXF service). This option starts a new process for each import/export operation with an Excel file. This should prevent in-process memory corruption.
AppDomain = Uses a new AppDomain instead of a new process. Should provide better performance but it’s unknown how well it works compared to Process-level isolation.
None = Does everything within the DIXF Service process. Default behavior.
Article ID: 4034779 - Last Review: 2017, ജൂലൈ 5 - Revision: 1