Hello, I have a flat file with records that can be of one of the specified 7 formats. Each format has different number of columns. The format is determined by the 1st column (Record Type) in each row. When I am creating the flat file connection manager its not recognizing the end of line and the data is being inserted into wrong columns. The End of Line is not CR LF and I cant figure out what it is. It just shows two square brackets before starting a new line in the Preview of the connection manager. Can anyone guide me as to what will be my End of Line or how do we import such files. Thanks, KK

Try using a Ragged Right type flat file. You just pick a column length that is longer than your longest column. This article can help you with handling the different columns: http://agilebi.com/jwelch/2007/05/08/handling-flat-files-with-varying-numbers-of-columns/Russel Loski, MCT