SSIS flat file destination, how to write line ending \x00\x00\x0d\x0a?
We have a format of flat file, it’s a text file with multiple columns of fixed length, and each record corresponds to one line in the text file. In this format, the line ends with \x00\x00\x0d\x0a
, which means two NUL
characters followed by line breaker. See the screenshots below for a demonstration in text and Hex editors.