I think the next thing I might try is a script task that reads in a line at a time and then applies logic to parse the line. I'm not sure what that logic would be because you have a very unusal input. But I'm sure it would involve finding the locations of the commas and quotes and then making decisions about whether they function as delimiters or data.