Hi, I am trying import flat file into sql server 2008 using ssis 2008. In the flat file for some of the rows, it contains \0 null terminator. So if this null terminator is found, it does not read till the end of the row once this character. I am using flat file connection source and reading the input type as byte stream. Please help on this Thanks,harin

1) Why can't you use other delimiters in flat file connection or source in data flow task? Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

If have used CR LF as the delimiter and also tired with other delimiters, but issue remains.Thanks,harin

Could you please post the sample text file data ?

You can Convert \0 By char or Number use below link for more Ans http://suhaskudekar.blogspot.com/2011/04/group-similar-text-together-using-fuzzy.htmlSUHAS R. KUDEKAR http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Here is sample file data 123456789 NUL 12315352 the value of NUL in binary 00 20 and it is null terminator \0Thanks,harin