How to read text file from mainframe through .net application?

Question

Some plain text file is stored in mainframe server, i have to read the file and populate the data to SQL database. Any ideas please suggest.

Answer 1

Assuming it's a member in a PDS FTP the member down to the PC, parse it, and insert the data into the SQL Server database. With out more information that's the best idea I can give you.

Answer 2

I'll 2nd Jared's suggestion but add that if you FTP the data make sure you specify the FTP options ASCII and CRLF (for plain text). This will translate the EBCDIC characterset to ASCII and append the CRLF record delimiter to each record in the text file.