Relative Content

Tag Archive for sql-serverssisfixed-width

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.