Resender (4/7/2014)
Ok I got the following issue:SSIS to import flat files,everything went fine for months,now suddenly errors.
At first the errors indicated an error in the file (the provider of the file has the habit of making undocumented & un-announced changes to the files)
But this time it wasn't it,so I checked the file and see the following situation,one of the fields start with a double quote (most likely to escape a quote)
For example: "RAC ('RAC)
The flat file has a text qualifier of ''.
So all of this worked fine,this scenario has happened before with no issue,suddenly now its an issue.
Sorry for brief,undetailed & maybe chaotic explanation,but let say I'm not really understanding why this is occuring
Starts with a double quote but does not end with one? And your text qualifier is "? I would expect an error.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.