Known Issue: Running a business adapter deletes the schema.ini file specifying the format of the text file containing source data to be imported unless delimiter is configured as "none" (IOJ-1737437)
Known Issue: Running a business adapter deletes the schema.ini file specifying the format of the text file containing source data to be imported unless delimiter is configured as "none" (IOJ-1737437)
Summary
When a business adapter is configured to import data from a text data file (commonly referred to as a "CSV file"), and a schema.ini file is supplied specifying the format of data in that file, the schema.ini file may be deleted when the business adapter is run.
Workaround
This issue can be worked around by edit the business adapter xml configuration file in a text editor (such as Notepad), and adding the following text in the properties of the ConnectionString attribute of the <Import> element:
See the following documentation pages for further information about importing data from text files and working with schema.ini files in business adapters:
Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.