While testing in the Design mode, I am getting an error :
1 Error whilst loading transform definition. Error - The quote character ["] at position [-1] is unterminated.
2 Error whilst loading workflow setup. The quote character ["] at position [-1] is unterminated.

When I schedule and run the job it works successfully.

The input data (attached) includes some quote-protected fields which actually contain Line Feed characters and I think this must be what’s triggering the error. One of the tasks in my Map transform is to replace any chr(13) and chr(10) with printable characters.

Is there any way I can cause the designer to process the file successfully, other than altering the input data? I notice that there are a couple of similar errors in the forum, but there was no indication of any other way to fix it.

Mary