rwheeler23
asked on
How to correct "column delimiter not found" message using SSIS
I recently discovered that the input csv file I was being given for an SSIS project had two of the column names changed. I have gone into the project and made these corrections and I also remapped all the fields. The problem I have now is that the project fails with the message "[Read CASES Flat File [2]] Error: The column delimiter for column "Incident No" was not found." This column is the last field of the row. I can view this file in Notepad and the Header Row delimiter is set to CRLF. If I preview the data all looks well. What can do to correct this issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER