Applies to Product – Dynamics 365 Commerce
What’s happening?
Customers may encounter errors while importing data using CSV files in the Data Management Framework (DMF), specifically SSIS errors indicating that the pipeline has failed. Common error codes include DTS_E_PRIMEOUTPUTFAILED and DTS_E_PROCESSINPUTFAILED, which may occur due to issues with file formatting or special characters in the data.
Reason:
The errors can occur if the import file is formatted incorrectly, such as when special characters are inadvertently added during file editing (e.g., using Microsoft Excel). This can lead to issues with row delimiters, column delimiters, and text qualifiers not being correctly positioned.
Resolution:
- Ensure that the CSV file is correctly formatted before import.
- Avoid using Microsoft Excel to edit CSV files, as it may introduce special characters. Instead, use a text editor like Notepad.
- Check for and remove any special characters at the start and end of the data rows.
- After correcting the formatting issues, attempt to import the file again.
- If the issue persists, consider using the CSV-Unicode format instead of standard CSV to handle special characters properly.