Copy a Textfile to a new location and encode to ASCII

Question

I am using the following powershell script to copy a text file from one location to another and then encode it so that it can be imported using a SQL bulk copy. The source file is encoded as UCS-2 Little Endian.

gc "\\SourceServer\Share\Person.txt" | Out-File -encoding ASCII \\dbserver\share\DataFlag\Person.txt

Can the same action be done in C# without using the powershell script?

score 1 · Accepted Answer · edited May 23 '17 at 12:04

1

As explained here, there is no direct support for UCS-2 in C# But it should be possible to read the file using a StreamReader with UTF-16 and compensate the differences by some additional byte-tweaking. Takes some research, though.

edited May 23 '17 at 12:04

Community

1
1

answered Feb 07 '13 at 10:16

Axel Kemper

10,544
2
31
54

Thanks, I may stick with the powershell script for simplicity – Hoody Feb 11 '13 at 14:35

Copy a Textfile to a new location and encode to ASCII

1 Answers1