Good day. The following are the errors that had occured while processing the flat file:
Source File is a Flat File Data Type properties for External Column and Output Column is identical: Data Type: String [DT_STR] Length is 1143
I've tried to experiment with the values in the properties, but I got no luck. What could be the reason for the error?
In addition, I tried to test 2 files. First file got success result, while the latter did not. Difference between them is, the first one is Dos\Windows, while the other is UNIX. Does it affect the behavior of the flat file?
Thank you so much for your input :)
Go to your flat file connection manager>>> Flat file Source Editor then >>> Click on Error Output >>>> and then to the column in question and select Ignore Failure. This worked for me. (That is if the column size is right)
User contributions licensed under CC BY-SA 3.0