Thursday, January 18, 2007

Flat File Issues


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:

Rafa Salas said...

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