Column && Row Delimiters To Read Flat Files Into SQL Table

Hi,

I have a package that reads a fixed width flat file data into a single CHAR column in an sql server 2005 table.

In the "Columns" tab of the Flat File Connection Manager, I set the RowDelimiter value to {LF} and nothing for the ColumnDelimiter (since I read the entire row from the flat file into a single column in my sql table).

However, in the "Advanced" tab, the ColumnDelimiter Misc property shows {LF}. This was working fine for me.

The problem I was facing was with some files which were recently identified to have rows containing a special character (probably ASCII ZERO) in the middle of the row. So, now if the record was having 400 characters and the 200 th character had this special character, the package was writing the first 200 characters into the sql table and ignoring the rest of the characters.

I am sure that the special character was ASCII ZERO - I wrote a script to read each character in the line and find the ascii code for it.

Has anyone faced this problem ever. If so, pls let me know your solution or any ideas that can help sort this problem. Your help would be much appreciated.

Thanks!!