This post is in reference to the thread "Flat File Source Problem" over at the MSDN SSIS forums.
After taking the sample data, I saved it to a text file. When first creating the flat file connector, I got the same error, however I did not have a CR-LF at the end of the last line. I opened the file, went to the end and hit Enter and then saved the file. I recreated the flat file connector, specifying "Vertical Bar {|}" as the column separator and everything worked.
1 comment:
Hey Phill,
Would you email me? I'd like to tell you something...my emai address in in my profile in the SSIS forum
Cheers,
Rafael Salas
Post a Comment