I am having issues doing the end to end exercise for chapter 8, I created the flat file connection manager successfully, when I preview the data from the connection manager and from the Flat file data source, the data is formatted perfectly, but when I dump the data to a union all, the double quote appears in all the values.
I cant post any screen shots here so I have posted them under stack over flow.
https://stackoverflow.com/questions/...21750#30521750
Is there any missing steps from the chapter that we should do to get this working?