Thread: Lesson 4
View Single Post
  #1 (permalink)  
Old November 25th, 2011, 10:25 AM
Femi Sonuga Femi Sonuga is offline
Registered User
Points: 22, Level: 1
Points: 22, Level: 1 Points: 22, Level: 1 Points: 22, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 4

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)
Reply With Quote