I’m using SSIS in Visual Studio 2019 to read fixed width text files. Depending on the first character of each row in the fixed width file, I’m sending the line to one of two specified outputs. Both outputs are configured with a length of 700, matching the text file fixed width.

In SSIS, i have a “Data Flow”, which contains “OLE DB Source” and Flat File Destination (CSV).
The Original CSV is also UTF-8:

The Flat file is UTF8:

When I Run it, data transfers correctly from SQL server to Excel file.
But there will be 1 empty line as the last line.
I wrote a c# script in “script task editor” , to remove the last empty line.
It also works correct BUT It changes the German alphabet (ä, ö, ü, ß):

Although i wrote in C# about keeping UTF8 format:

I have an Excel sheet that I need to import to SQL Server database.

I have an email column in a table that I want to automate with script task but there’s an email column that contains values with characters in it like an apostrophe. How do I bypass it in posted script?