I am currently doing the Lesson 4 Try It Yourself section. My data flow task is currently failing at the flat file destination.
I have removed it and done a debug from the Person Source to the Add Full Name – that came back with all green. It was only when I put the flat file destination and tried to do a debug that I am getting issues
Yes I am following the steps in sequence. The only difference is the table name in the OLE DB Person Source, where your table stated Person.Person ( I tried that and it failed, - I then went to SSMS and found out mine states Person.Contact)