Summary

When running a business adapter to import data from a CSV file and format details for the CSV file are configured in an associated schema.ini file, the error below may be reported if the Column delimiter setting in the business adapter file is set to the value “Semicolon”:

An error has occurred when trying to run the query [select * from [Test.csv]]. 
The error message is [The process cannot access the file '<Path to file>\Schema.ini' because it is being used by another process.].
The process cannot access the file '<Path to file>\Schema.ini' because it is being used by another process.

Workaround

• In the Business Adapter Studio UI, remove the value in the Column delimiter property on the data source properties page by highlighting and deleting it.
• Alternatively, edit the adapter configuration XML file directly and replace the Delimiter attribute on the <Import> element with “None”. For example, instead of:
  <Import Type="CSV" Delimiter="Semicolon" [...]>
  use:
  <Import Type="CSV" Delimiter="None" [...]>